Total expenses by category
You run a small bakery and track all expenses in one sheet. You need to quickly see how much you spent on "Ingredients" this month.
Total expenses by category
Practice using SUMIF to solve a real small business problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
You run a small bakery and track all expenses in one sheet. You need to quickly see how much you spent on "Ingredients" this month.
Write a SUMIF formula that sums column C (Amount) where column B (Category) equals "Ingredients".
SUMIF adds up the rows in a column that match a single condition. You give it a range to test, the criterion, and the range to total. The fastest way to answer 'how much did East region sell?' or 'how much is overdue?' without reshaping the data.
SUMIF(range, criteria, [sum_range])Try the formula first. Hints cost CP for a reason.