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

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 :o)

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

Hi!

Try this:

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

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

Biff

"Confused" wrote in message
...
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 :o)

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

Thanks Biff ... u da best!!! :o)

"Biff" wrote:

Hi!

Try this:

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

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

Biff

"Confused" wrote in message
...
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 :o)

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

You're welcome!

Biff

"Confused" wrote in message
...
Thanks Biff ... u da best!!! :o)

"Biff" wrote:

Hi!

Try this:

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

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

Biff

"Confused" wrote in message
...
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 :o)