sum of cells within a month...

Giganews Newsgroups
Subject: sum of cells within a month...
Posted by:  james (james.cond…@guidant.com)
Date: Fri, 24 Oct 2003

is there a way to do this;
i would like to add the values in a range of cells based on the dates of
another range of cells.

for example:

      6401936 4/17/2003 G025498 21,500.00 28860 5/9/2003
      6425598 4/23/2003 G025852 32,650.00 28860 5/9/2003
      6401938 4/17/2003 G025498 21,500.00 28860 5/12/2003
      6430847 4/24/2003 G025999 35,150.00 28860 5/12/2003
      6430849 4/24/2003 G025999 21,950.00 28860 5/12/2003
      6489337 5/8/2003 QC03044 21,500.00 28860 5/12/2003
      6437699 4/25/2003 G026497 21,500.00 28860 5/27/2003
      6503075 5/12/2003 G025252 25,500.00 28860 5/27/2003
      6532399 5/19/2003 G025498 21,500.00 28860 5/27/2003
      6535052 5/19/2003 QC03756 22,750.00 28860 6/11/2003
      6118595 2/13/2003 QC03756 21,500.00 28860 6/24/2003
      6199601 3/4/2003 QC03756 21,500.00 28860 6/24/2003

can i add up the 3rd column based on only the month of MAY in column 5?
then continue with June's numbers?

Replies