SumIfs

G

Guest

B C D
E
Payee Account Category Amount
A. Datum Corporation Cash Publications 18.80
Adventure Works 2877 Furnishings 58.94
Alpine Ski House Cash Publications 177.00

I have a list that is 925 rows in length and I would like to be able to add
all the payees amount details that are for cash. ie all Datum Corporation
who paid in cash. I tried =SUMIF(C2:C925,"A. Datum Corporation,Cash",E2:E925)
I got into a bit of a pickle!!
Any boffs out there with the knowledge would be greatfully received.
Regards. P
 
G

Guest

Try this:

=SUMPRODUCT(--(B2:B925="A. Datum Corporation"),--(C2:C925="Cash"),(E2:E925))

HTH,
Elkar
 
G

Guest

I would use sumproduct
=sumproduct(--($b$2:$b$925="A.datum
corporation"),--($c$2:$c$925="Cash"),$e$2:$E$925)
 
Top