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.
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 exerciseMore exercises in Conditional counting and summing
- Spend for one category
- Late deliveries
- Open high-priority tickets
- Sales for one rep and month
- Won deals above a minimum
- Average reply time
- Largest order in a region
- Cheapest item in stock
- Orders between two dates
- Customer tiers with IFS
- Region names with SWITCH
- Contacts on one email domain
- Active SKUs with a prefix
- Free shipping rule
- Weighted average score
- Rank without RANK
- Everything except one status
- Average rating without the zeros
- Contacts with no email