ADDING ROWS TO AUTOSUM

[MATTB]

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

 

[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

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

 

[Dave Peterson]

another way:

=sum(b2ffset(b21,-1,0))

David McRitchie has some notes at:
http://www.mvps.org/dmcritchie/excel/offset.htm