Sumif?

[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

[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)

"Akira" <[email protected]> wrote in message
news:[email protected]...
> 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