SheetsdrillTotal ad spend
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
Six marketing channels and their spend for the month are listed. Click B8, type a formula in the formula bar that adds up all six, press Enter, then choose Check answer.
What this exercise teaches
SUM takes a whole range, so the total updates by itself when any channel changes.
A hint if you get stuck
Every formula starts with =. A range such as B2:B7 means every cell from B2 down to B7.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise