CODEWITHSUNDEEP
excelsum
Selrac
Selrac

Reputation: 2293

Excel sum based on matrix condition

I need to create dynamic sum formula in Excel with conditions based on a matrix table. I've represented an example below:

enter image description here

The sum val is based on what is selected in the matrix with an 'X'. If the 'X' changes to other references, the formula should be changed to reflect the change and sum the relevant values.

Any ideas?

Upvotes: 1

Views: 96

Answers (1)

pnuts
pnuts

Reputation: 59440

Please try:

=MMULT(--(B9:F9="X"),C$2:C$6)

Upvotes: 1

Related Questions