I need help writing a formula to add a column of numbers until a value is reached, then start over adding numbers starting at the next cell after the value is reached.
Thanks for any help.
45Romeo
I need help writing a formula to add a column of numbers until a value is reached, then start over adding numbers starting at the next cell after the value is reached.
Thanks for any help.
45Romeo
Last edited by 45romeo; 02-25-2010 at 05:17 PM.
Assuming you are starting in row 2, say A2, and B1 is an empty cell, then in B2, try something like:
=IF(B1+A2>1000,A2,B1+A2)
copied down
where 1000 is your threshold
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Edit: Removed comments about VBA in light of NBVC's suggested solution.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thats it--Thanks
Last edited by 45romeo; 02-25-2010 at 05:15 PM. Reason: made a mistake
Isn't that what it is doing?
See attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks