Thread: SumIfs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
timson timson is offline
external usenet poster
 
Posts: 2
Default SumIfs

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