Forum Discussion
Solved
Matrix Search? Summing up values with defined criteria
Hello Excel forum, I am looking for a maybe quite complex formula (or I think too complex 🙂 ) and hope someone can help me. Can you tell me how to make a sum of values depending on several c...
In B37:
=SUMPRODUCT(($A$2:$O$32=B$36)*($A$1:$O$1=$A37))
Fill down, then to the right (or vice versa).
See the attached version.
In B37:
=SUMPRODUCT(($A$2:$O$32=B$36)*($A$1:$O$1=$A37))
Fill down, then to the right (or vice versa).
See the attached version.
Thank you very much. This formulae solved my issue 🙂