How to use the IF function to tally data
I have a spreadsheet for logging jobs I do for various clients and would like a separate tally to total the amount charged to each client.
In column A I have the client's names, column B the amount of each separate invoice. Either further down the page or on a different page I'd like to use the IF function to calculate the total amount claimed from unique clients. I'm sure I did something like this years ago but cannot exactly remember the sum used. It was something like =IF(C$2:C$7,"mcdonalds", F$2:F$7).
I'm sure it's a painfully small amendment, but would appreciate any suggestions.
Thanks
May be you are trying to
May be you are trying to apply sumif function, try below:-
=SUMIF(C$2:C$7,"mcdonalds", F$2:F$7)
Regards,
DILIPandey
Hit the nail on the head
Many thanks DILIPandey, that's exactly what I was doing wrong. I'll try not to forget that again.
Cheers
You are welcome
You are welcome achtung_boy.
Cheers:)
Regards,
DILIPandey