• 411K Members
• 7,106 Online
• 466K Conversations
SOLVED

## IF Function - May be a diff function

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

# Re: IF Function - May be a diff function

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

# Re: IF Function - May be a diff function

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

# 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.
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"

# Re: IF Function - May be a diff function

Thank you so very much, makes perfect sense.

# 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)

# 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)

# 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 :)
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies