» Summing Annual Expenses by Respective Quarters
The range A2:B9 contains a list of dates with corresponding expenses.
We want to create a total of the expenses paid during each quarter.
Use the SUM, ROUNDUP, and MONTH functions as shown in the following Array formula:
|Screenshot // Summing Annual Expenses by Respective Quarters |