Autosum when some cells are blank

  • Thread starter Thread starter sue
  • Start date Start date
S

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!
 
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.)
 
Back
Top