In case you/user enter(s) data into your table, then it is poorly designed - and as result you have difficulties to make any calculations based on this table.

In attachment is an alternative.

On sheet DataTable user enters parameters for item - a single parameter on row. In case the user enters some parameter twice, the entry is blocked and a message pops up (Data Validation). (Data Validation formula uses Names, defined in FORMULAS>Name Manager.)

On sheet PivotTable a Pivot Table report is designed, which is an analog of your table.

Attached Files

example.xlsx (13.8 KB, 10 views)