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

DILIPandey's picture

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

DILIPandey's picture

You are welcome

You are welcome achtung_boy.

Cheers:)

Regards,
DILIPandey