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