I would like to have calculate net travel for a project. Basically, I would like to add all the floor to floor heights. I used the sum function by selecting the first and second column.
But the problem is that the number of floors keep on changing and I would like have the net travel cell range equation change automatically based on the number of rows. An example is attached. I want the modified table sum range go automatically to =Sum(B2:B10).
It's a quirky, finicky kind of thing in a table that uses a formula. Using your example, 121'-7" is the sum of cells from B2 to B8 or...........from a defined top cell to a defined the bottom cell. If you INSERT rows 9 and 10 below cell B8 , then the values 14'-0" and 13'-0 3/8" are ignored because they are outside the 'defined' range, or outside B2 top to B8 bottom.
If you INSERT inbetween the top and bottom cells, or within the range, for instance insert two rows after row 6 and before row 7, then you are within the top cell and bottom cell and the formula will change to =SUM(B2:B10), see image below, which will include the values in B9 and B10. I know, I know, if you do it that way then your sequence in column A will be incorrect. In this case simply cut floor 7-8 and paste it below floor 6-7. Then insert the new entries on rows 9 and 10.
Chicagolooper
