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