Forum Discussion
Solved
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 formul...
- 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"
=SUMIFS(B:B,A:A,"woolworths")
- 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)
- I have a Profit and Loss Sheet per month and I need to find all "woolworths" receipts and have them totaled on my summary.