count in column and restrict output

[excel_lover]

Hi All,

A quick question for you guys im strugling on. I have a value at the top of my sheet in column A row 1. The value is the result of a lookup and it is a number between 50 and 100.

On the same sheet I have rows starting at row 5 and working their way down to about 200. In col D of rows 5 to 200 is a value in each row and what I need to do is to only display as many of the rows between 5 and 200 that add up from the top to the value in A1.

So an example is
A1 shows as 50
D5 = 10
D6 = 12
D7 = 10
D8 = 10
D9 = 10


So in this case there is the option of adding up D5:D8 and only having 42 or adding D5:D9 and achieving 52. I always need to go for the figure or slightly above.

Is there any way to do this? I hope i explained it well enough, let me know if you want me to elaborate.

Many Thanks

[NBVC]

Something like this:

=IF(SUM($D$5:D5)<$A$1+5,D5,"")

copied down to row 200

Note: The +5 allows for "slightly" over your A1 value by a maximum of 5 more.

[excel_lover]

thanks a lot that solves it just right