Sheetsdrill

Level 2: Conditional counting and summing Exercise 33 of 92

Revenue for one month

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

E1 holds the first day of a month. Add up the amounts dated in that month, from the first day to the last day, both included. Work out the last day from E1 instead of typing a date. Answer in E2.

What this exercise teaches

A month is a date range, so a monthly total is a SUMIFS between its first and last day. EOMONTH finds the last day whatever the length of the month, and amounts dated on either end are included.

A hint if you get stuck

Two conditions on the date column in one SUMIFS: ">="&E1 and "<="&EOMONTH(E1,0). EOMONTH(date, 0) is the last day of the same month.

Functions used: EOMONTH, SUMIFS

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