Sumif function

[HES1985]

Hi

I have a list on one spreadsheet with a list of names and whether they paid by cash or cheque and then another column of the value of the cash/cheque.

Joe Bloggs cash 100
Billy Bloggs cheque 50
Mary Bloggs cash 60

On another spreadsheet, I would to calculate the value of all the cash or the cheque

Cash 160
Cheque 50

Do I use the sumif function for this?

Thanks

[Glenn Kennedy]

Yes - unless you want to separate Joe from Billy fromMary, in which case you need SUMIFS.

If you don't..

=sumif(C1:C3,"Cash") will give you the cash total... etc; assuing of course that the name, payment method and amount are in different columns.

[HES1985]

Thanks for that.

That is not working for me. What I want to do is get a formula for the total for the amount of cash and the total amount of cheques.

person 1 Cash 100
person 2 Cheque 150
person 3 Cash 100
person 4 Cheque 120
person 5 cash 130


total cash
total cheque

[Glenn Kennedy]

You're right. I'm being VERY thick...

=SUMIFS(C1:C5,B1:B5,"Cash")... or

=SUMIF(B1:B5,"Cash",C1:C5)

[HES1985]

Thanks a million. That was the formula I was using all along, but it wouldn't work, but then I realised my C and B columns weren't the same. eg (C1:C7, B1:B4).

[Glenn Kennedy]

Ah welll.. we can all have our "off" days...