Hi,
I have tried searching for a solution to my problem, but I can't even figure out how to describe my issue simply enough to get relevant search results.
My formula in this case would be [sum(B1:B3)-sum(A1:A3)]/sum(A1:A3).Please Login or Register to view this content.
However, if there was a number at B4, then the formula would be [sum(B1:B4)-sum(A1:A4)]/sum(A1:A4).
If there was a number at B5, then the formula would be [sum(B1:B5)-sum(A1:A5)]/sum(A1:A5).
* There will never be a gab in between two rows. So B1=160, B2=140, B4=100 is impossible.
So how can I make a formula that will always work no matter if colum B goes all the way down to 2...6,7 or 8?
Thanks
Bookmarks