May 08 2019 12:37 AM
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
May 08 2019 12:43 AM
May 08 2019 12:47 AM
May 08 2019 12:47 AM
SolutionMay 08 2019 12:49 AM
May 08 2019 12:55 AM
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)
May 08 2019 12:55 AM - edited May 08 2019 12:56 AM
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)
May 08 2019 02:17 AM
May 08 2019 12:47 AM
Solution