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

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

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Akira" wrote in message
...
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