View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
confused confused is offline
external usenet poster
 
Posts: 193
Default 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)