Sales per month from a date column
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
From Priya in Finance: "I need the sales per month. Column E has the first day of each month. Put the month totals in F2:F4, and work out where each month ends from the date in column E instead of typing dates."
What this exercise teaches
A month is a date range, so a monthly total is a SUMIFS between the first and the last day. EOMONTH(E2,0) finds the last day whatever the length of the month, and sales dated on the first or the last day are included.
A hint if you get stuck
One SUMIFS with two date conditions: on or after the first day (">="&E2) and on or before the last day ("<="&EOMONTH(E2,0)). Lock the data ranges with $.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill 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