I have a cell (A35) that displays the sum of the cells in range
A9:A33. The cells in this range are pre-populated based off another
cell's data divided by 24. Cell A35 is set to show a max total of
$230,000 even if the cells add up to more than that. However, the
cells in column A may add up to $230,000 before reaching A33. If that
happens, I'd like the cells that are left (haven't been added yet) to
display a 0 or dash. I am thinking that there needs to be some sort
of formula running in the background that keeps a running total of
column A. Then once the total of column A has exceeded $230,000, the
rest of the cells in the range in column A need to display a 0 or
dash. I hope that makes sense--it's difficult to put it into words.
Thanks!