have 5 receipts
- $42.00, $220.00, $55.00, $100.00 and $25.00. For example i want them to be sorted into 3 categories food, gas, entertainment.
Is there a way using the IF function or something else that if i entered them as fallowed in cells c4:c9 they would be automatically sorted and totaled.
result would be $97.00 gas, $220.00 Food, $25.00 Entertainment in lets says cells E7,E8,E9 accordingly?