how to add all values above row that meet multiple criteria criteria

r.png

I want to add up all values above and including the row that meet two criteria. Unfortunately i cannot post a picture

In this example i want to sum the values including and above the row that meets two criteria.

So criteria in column A and B and want to sum the values located in column C

anyone can help?

Please post a workbook with before and after data.

Something like this might work But it is difficult to provide an answer without seeing your data

=SUMPRODUCT(--($A$2:$A$10=E4),--($B$2:$B$10=F4),$C$2:$C$10)

E4 and F4 contain the criteria to be matched in columns A and B respectively.

This will work if I understand you description correctly...

=SUM(C2:INDIRECT("C"&LARGE(INDEX((A2:A7=E4)*(B2:B7=F4)*ROW(C2:C7),0),1)))

Result is 9:00