LinkBack URL
About LinkBacks
Hi,
I currently have this formula to deal with this:
=SUM(J5:INDEX(J:J,ROW()-1))
However, whenever I delete the top row...I get a reference error and have to re-adjust...any ideas on how to get aorund this?
Hi,
I currently have this formula to deal with this:
=SUM(J5:INDEX(J:J,ROW()-1))
However, whenever I delete the top row...I get a reference error and have to re-adjust...any ideas on how to get aorund this?
=sum(indirect("j4"):index(j:j,row()-1))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
thanks a lot
One question...why J4 and not 5?
Or, to avoid volatility,
=sum(index(j:j, 5):index(j:j, row() - 1))
Last edited by shg; 07-21-2014 at 11:28 AM.
Entia non sunt multiplicanda sine necessitate
Thanks.
Wondering why row 4 and not 5 as row 5 is when the data starts
Seems to work either way
It should be 5. If it works either way, then J4 is empty, or contains text, or contains 0.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks