View Single Post
  #1   Report Post  
Chris
 
Posts: n/a
Default Using the Month function to sum another column

I have a column with dates and another with totals. I want to for every month
(01 - 12) to search all the rows in columnA and sum the totals only relevent
to the month from columnB. E.g for OCtober the total is 1500
ColumnA columnB
10/10/04 1000
10/10/04 500
10/09/04 250