Autosum ignoring empty cells (97 SR-2)

Topic

New Reply

Is there a way to add all the cells in a column using autosum when some of the cells have no values in them?

clark

Reply | Quote

Replies

What do you want to add to the sum for an empty cell?

Reply | Quote

The empty cell has the value of 0, but unless I put in 0, Excel ignores the cell. So, if I have a column of 10 cells, the first six (A1 through A6) have values, the seventh (A7) is empty, and A8, A9, and A10 have values, if I want to add the column by putting an autosum formula in A11, Excel only gives me the sum of cells A8 through A10, whereas I want the sum of all cells (A1 through A10).
Clark

Reply | Quote

After you press the AutoSum button, you can change the selected cells to whatever you want. As an alternative, you can pre-select the cells for the sum along with an empty cell at the bottom and press the AutoSum button.

Reply | Quote

Highlight the block of cells you wish to sum and click on the Autosum icon. this will then add an sum() to the end of your block.

Peter

Reply | Quote

If you mean how to expand the selected cels you get when you press the Autosum button, simply hold the shift key and press arrow-up until you’ve reached the range you want.

Reply | Quote