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.
|