Named Range of dates

[tigersden]

Hi,
I am trying to summarise the totals for specific months. I have created a dynamic named range which covers all the dates in the column and another named range for the amounts to be totalled.
How can I now sum the totals for each month?
I have tried the month command using the named range but it will not work
Thanks in advnce

 

[Andrew Poulsom]

You could create a Pivot Table grouped by month, or you could use a formula like this:

=SUMPRODUCT(--(MONTH(A1:A100)=MONTH(C1)),(B1:B100))

where C1 contains a date whose monthly total you want. You can replace A1:A100 and B1:B100 with named ranges, provided that they have the sme number of rows.