"Luke" wrote...
Is there a way to add the numbers in row 2 that have the same date
so that if the result is Equal to, OR, minus 1 to 3 before, OR,
plus 1 to 3 over (say 30), then diplay the result, otherwise
display nothing? Formula needs to be in row 3 and if the date are
different, as in B1, then the calculation would start over with
the new date in the next column.
Desired results are shown in row 3
My attempts have resulted in formula that is too long.
A B C D
1 Date 8/29/02 11/6/05 11/6/05
2 Draft 16 20 7
3 New 16 27

Would the row 1 dates always be ordered older to newer left to right? If so,
enter the following formula in B3.

B3:
=IF(COUNTIF($A$1:A$1,B$1)=0,SUMIF(B$1:$IV$1,B$1,B$ 2:$IV$2),"")

Fill B3 right as far as needed.