Formuladrill

Level 6: Work mode Exercise 104 of 118

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 $.

Functions used: EOMONTH, SUMIFS

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

More exercises in Work mode