• 669K Members
• 6,893 Online
• 824K Conversations
SOLVED

## IF Function - May be a diff function

Highlighted
Occasional Contributor

# IF Function - May be a diff function

Hi all,

I run a sports canteen and I am looking to have 1 sheet for all receipts. My query is:

Col A Suppliers Names (Woolworths, Coles etc...)

Col B Receipt Amount

I want to have a formula on my Summary sheet where all "Woolworths" receipts will total, same goes with all other Suppliers. I can do this manually, but I was hoping there was a way I could do maybe an IF(Cell Range="woolworths" then the 'receipt amount' would tally)

Any advice would be great, thank you

8 Replies
Highlighted

# Re: IF Function - May be a diff function

=SUMIFS(B:B,A:A,"woolworths")
Highlighted

# Re: IF Function - May be a diff function

Wow that was quick, thank you. do you mind explaining it to me please.

Highlighted

# Re: IF Function - May be a diff function

I have a Profit and Loss Sheet per month and I need to find all "woolworths" receipts and have them totaled on my summary.
Highlighted
Solution

# Re: IF Function - May be a diff function

Sure, SUMIFS sums up a range of cells based on another range of cells

So you are summing Column B based on the values in column A = "woolworths"

Highlighted

# Re: IF Function - May be a diff function

Thank you so very much, makes perfect sense.
Highlighted

# Re: IF Function - May be a diff function

No Problem @Cass_M

I guess you're a fellow Aussie ;)

Another approach is to use a Pivot Table to summarise your data (see the attached example)

Highlighted

# Re: IF Function - May be a diff function

No Problem @Cass_M

I guess you're a fellow Aussie ;)

Another approach is to use a Pivot Table to summarise your data (see the attached example)

Highlighted

# Re: IF Function - May be a diff function

Sure am :) Pivot Table, hmmm Ill check it out, I have great ideas, just not sure how to implement them, so may hit you up for some more advice down the track, thank you :)