SUMIF
Add up the cells in a range that meet a single condition.
SUMIF totals values where a matching condition is true — for example, summing all amounts tagged "Sales".
Excel
=SUMIF(A:A, "Sales", B:B)Google Sheets
=SUMIF(A:A, "Sales", B:B)How it works
- 1A:A is the range to test.
- 2"Sales" is the condition.
- 3B:B is the range whose matching values are summed.