sum of cells within a month...

  • Thread starter Thread starter james
  • Start date Start date
J

james

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?
 
thanks for the prompt replies!!

question on this one:

=COUNTIF(A1:A10,">=1/1/03")-COUNTIF(A1:A10,">=6/1/03")

it adds up A1 thru A10 if the cell value equals >=1/1/03". is there a way to
have it sum a different cell range while still using the month criteria
found in A1:A10?


Ken, the link you gave me is down for the moment.
 
Back
Top