SOLVED
Home

IF Function - May be a diff function

%3CLINGO-SUB%20id%3D%22lingo-sub-545506%22%20slang%3D%22en-US%22%3EIF%20Function%20-%20May%20be%20a%20diff%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545506%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20run%20a%20sports%20canteen%20and%20I%20am%20looking%20to%20have%201%20sheet%20for%20all%20receipts.%20My%20query%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECol%20A%20Suppliers%20Names%20(Woolworths%2C%20Coles%20etc...)%3C%2FP%3E%3CP%3ECol%20B%20Receipt%20Amount%3C%2FP%3E%3CP%3EI%20want%20to%20have%20a%20formula%20on%20my%20Summary%20sheet%20where%20all%20%22Woolworths%22%20receipts%20will%20total%2C%20same%20goes%20with%20all%20other%20Suppliers.%20I%20can%20do%20this%20manually%2C%20but%20I%20was%20hoping%20there%20was%20a%20way%20I%20could%20do%20maybe%20an%20IF(Cell%20Range%3D%22woolworths%22%20then%20the%20'receipt%20amount'%20would%20tally)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20would%20be%20great%2C%20thank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-545506%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545527%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20-%20May%20be%20a%20diff%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545527%22%20slang%3D%22en-US%22%3E%3DSUMIFS(B%3AB%2CA%3AA%2C%22woolworths%22)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545535%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20-%20May%20be%20a%20diff%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWow%20that%20was%20quick%2C%20thank%20you.%20do%20you%20mind%20explaining%20it%20to%20me%20please.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545544%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20-%20May%20be%20a%20diff%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545544%22%20slang%3D%22en-US%22%3EI%20have%20a%20Profit%20and%20Loss%20Sheet%20per%20month%20and%20I%20need%20to%20find%20all%20%22woolworths%22%20receipts%20and%20have%20them%20totaled%20on%20my%20summary.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545546%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20-%20May%20be%20a%20diff%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545546%22%20slang%3D%22en-US%22%3ESure%2C%20SUMIFS%20sums%20up%20a%20range%20of%20cells%20based%20on%20another%20range%20of%20cells%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20you%20are%20summing%20Column%20B%20based%20on%20the%20values%20in%20column%20A%20%3D%20%22woolworths%22%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545547%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20-%20May%20be%20a%20diff%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545547%22%20slang%3D%22en-US%22%3EThank%20you%20so%20very%20much%2C%20makes%20perfect%20sense.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545550%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20-%20May%20be%20a%20diff%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545550%22%20slang%3D%22en-US%22%3E%3CP%3ENo%20Problem%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F337839%22%20target%3D%22_blank%22%3E%40Cass_M%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20you're%20a%20fellow%20Aussie%20%3B)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20approach%20is%20to%20use%20a%20Pivot%20Table%20to%20summarise%20your%20data%20(see%20the%20attached%20example)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545551%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20-%20May%20be%20a%20diff%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545551%22%20slang%3D%22en-US%22%3E%3CP%3ENo%20Problem%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F337839%22%20target%3D%22_blank%22%3E%40Cass_M%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20you're%20a%20fellow%20Aussie%20%3B)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20approach%20is%20to%20use%20a%20Pivot%20Table%20to%20summarise%20your%20data%20(see%20the%20attached%20example)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545767%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20-%20May%20be%20a%20diff%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545767%22%20slang%3D%22en-US%22%3ESure%20am%20%3A)%20Pivot%20Table%2C%20hmmm%20Ill%20check%20it%20out%2C%20I%20have%20great%20ideas%2C%20just%20not%20sure%20how%20to%20implement%20them%2C%20so%20may%20hit%20you%20up%20for%20some%20more%20advice%20down%20the%20track%2C%20thank%20you%20%3A)%3C%2FLINGO-BODY%3E
Cass_M
Occasional 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.
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 :)
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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies