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

Thank you

Luke

## Bookmarks