G
Guest
Is there a way to make the sum function's range auto update when rows are
added above it. An example would be:
I have the following formula in K20, =SUM(K15:K19). If row 20 is selected
and a new row is inserted, the formula still sums K15:K19. I would like the
formula to update to =SUM(K15:K20) after the row is inserted.
Thanks
Dave
added above it. An example would be:
I have the following formula in K20, =SUM(K15:K19). If row 20 is selected
and a new row is inserted, the formula still sums K15:K19. I would like the
formula to update to =SUM(K15:K20) after the row is inserted.
Thanks
Dave