SOLVED

IF Function - May be a diff function

Copper Contributor

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
=SUMIFS(B:B,A:A,"woolworths")

@Wyn Hopkins 

 

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

I have a Profit and Loss Sheet per month and I need to find all "woolworths" receipts and have them totaled on my summary.
best response confirmed by Cass_M (Copper Contributor)
Solution
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"

Thank you so very much, makes perfect sense.

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)

 

 

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)

 

 

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 :)
1 best response

Accepted Solutions
best response confirmed by Cass_M (Copper Contributor)
Solution
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"

View solution in original post