Forum Discussion
Solved
Add cells with different criteria within the same range of cells
Ok friends, what formula should I use, for example, if I have a range of cells and I need to add up the "Food" and "Beverage" expenses and place that result in the "Expenses" cell, which of the Sum formulas should be used.
You can try the example 2 of SUMIF-function from https://support.office.com.
e.g.
=SUMIF(A2:A7,"Food",C2:C7) + SUMIF(A2:A7,"Beverage",C2:C7)
1 Reply
You can try the example 2 of SUMIF-function from https://support.office.com.
e.g.
=SUMIF(A2:A7,"Food",C2:C7) + SUMIF(A2:A7,"Beverage",C2:C7)