Forum Discussion
How to SUM Data from non-regular rows
I am collecting data from source which omits categories with zero values. Therefore, number of rows will never be the same. Columns will always remain the same. I need to create an annual report base...
In the attached file, the formula in C15 is:
=SUMPRODUCT(C$2:C$11,
($A$2:$A$11=$A15)*
($B$2:$B$11=$B15))
Please confirm if the foregoing formula returns your desired results.