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"
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 :)