Autosum when some cells are blank

[sue]

Is there a way to autosum so that Excel will ignore the
blank cells but still add all of the other cells in a
row? I have a large spreadsheet with 1000 rows in it and
would like to click on autosum w/o having to change the
cell reference. Thanks!

 

[Dave Peterson]

If you select your range first, then hit the autosum button, excel put the
formula in next row.

And one way to select the range is to click on the top cell and shift-click on
the bottom cell. (Use the vertical scroll bar to get to the bottom cell.)

(yeah, it still might be easier to just remember the first row and adjust the
formula.)