Linking a monthly total to the last date of each month

In this spreadsheet (attatched) I wish to create totals in columns D and E which are linked to the last date of each month in Column A. Is there a formula I can create so that it will automatically add together totals on the last day of each month.?
And if so: the dates running down Column A miss out sundays, what happens if the month ends on a sunday?

Hi,

I think this is what you mean.

I've put in formulas to show it two ways. The first way is how you have it set up. It will not matter if the last day of the month falls on a Sunday. The second way is a simpler formula and shows a month by month totals table.

Let us know if that's not what you meant at all..

S.


Payments In (2).xlsx

Or you mean this:

Write in D3 and pull right and down:

=IF(A3="Total", SUMIF(A$3:A3,"Total",B$3:B3), "")

Thanks to you both..all of the above solve my problem, i might just use all three, haha