Sumif?

A

Akira

I need to do a running total from col C for each condition of column A
and B



col A col B col c Summary

A AA 1 A AA 2
A AA 1 B BB 1
B BB 1 B AA 1
B AA 1 C BB 1
C BB
 
B

Bob Phillips

=SUMPRODUCT(--($A$1:$A$100="A"),--($B$1:$B$100="AA"))

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top