sub total change in monthly dates

[lastnotice]

I have a column which has dates in chronological order from oldest to newest.

Example:

01/Jan/2016
02/Jan/2016
20/Jan/2016
04/Feb/2016
15/Mar/2016

Beside each date is an amount in dollar figure. I want a total for this dollar figure for each month. How do I do this?

 

[Jerry Sullivan]

If you are analyzing data, a PivotTable would probably be the best tool. The data can be grouped by months.

If you prefer to use the SubTotal worksheet feature, you could add a helper column that uses a formula to read the month.
Assuming your dates are in Column A, then in B2:
=MONTH(A2).

You can then use the SubTotal feature on the Ribbon to add Subtotals with each change in Column B.