G
Guest
I HAVE ROWS B2:B20 AUTOSUMED IN B21. IF I ADD A NEW ROW BEFORE THE AUTOSUM THE FORMULA IS NOT PICKING UP THE NEW ROW ANY SUGGESTIONS
mb
mb
D
DDM
Matt, suggest you place your formula in B22, leaving B21 blank. Formula will
be =SUM(B2:B21). When you insert rows, insert them above Row 21 (right-click
B21 and select Insert > Shift cells down > OK).
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
be =SUM(B2:B21). When you insert rows, insert them above Row 21 (right-click
B21 and select Insert > Shift cells down > OK).
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
AUTOSUM THE FORMULA IS NOT PICKING UP THE NEW ROW ANY SUGGESTIONSMATTB said:
D
Dave Peterson
another way:
=sum(b2
ffset(b21,-1,0))
David McRitchie has some notes at:
http://www.mvps.org/dmcritchie/excel/offset.htm
=sum(b2
ffset(b21,-1,0))David McRitchie has some notes at:
http://www.mvps.org/dmcritchie/excel/offset.htm