#### pdxstarflyer

##### New Member

- Joined
- Jan 12, 2010

- Messages
- 35

I'm trying to sum column "I" starting from the most recent entry (as determined by date in column "B" and is 99% of the time the last row on the sheet) and, summing column "I" backwards, return the date from column "B" where the most recent date or dates in column "I" >=3. On top of that I only want to do this when column "C" equals X

Example 1:

3/1/11 X 3

3/2/11 X 2

3/3/11 X 1

3/4/11 X 0

3/5/11 X 3

3/6/11 Y 1

3/7/11 Y 2

The formula should return the date "3/5/11" because that is the where X>=3 counting backwards from today.

Example 2:

3/1/11 X 3

3/2/11 X 2

3/3/11 X 1

3/4/11 X 0

3/5/11 X 1

3/6/11 Y 1

3/7/11 Y 2

The formula should return the date "3/2/11" because that is the where X>=3 counting backwards from today.

I'm really at a loss and have tried all the basic tricks I know. Any pointers will be much appreciated!