How do I add totals from a range of dates depending on the month?

C

Confused

I am trying to write a formula to add all totals for each month irrespective
of the year. So an August total and a September total in this case. Any
ideas???

30/08/2006 $70
30/08/2006 $45
30/08/2006 $21
01/09/2006 $35
01/09/2006 $100
01/09/2006 $50
30/08/2007 $70
30/08/2007 $45
30/08/2007 $21
01/09/2007 $35
01/09/2007 $100
01/09/2007 $50

Thanks :eek:)
 
B

Biff

Hi!

Try this:

=SUMPRODUCT(--(MONTH(A1:A12)=8),B1:B12)

Just change the month number (=8) as needed.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

When building a chart Dates are been included that are not in thedate range 2
IF calculation of Time 2
Please help for FV and XIRR function. 3
sum of info in a range based on dates 4
How to get the array like this? 6
Summarise data by Month 7
Is there a way to break down dates by month in a report? 6
Excel 2002: How to get the number of days in the month ? 9

Top