Sheetsdrill

Level 2: Conditional counting and summing Exercise 16 of 92

Spend for one category

A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Add up the expenses in the category typed in E1. Point at E1 instead of typing the category, so the total follows when it changes. Answer in E2.

What this exercise teaches

SUMIF tests one column and adds another. With a cell as the criterion, changing E1 turns the same formula into the total for any category.

A hint if you get stuck

SUMIF(range to test, criterion, range to add). The criterion can be a cell.

Functions used: SUMIF

Try it now, free, no account needed

Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Conditional counting and summing