ExcelBanter - AUTO SUM function returns 0.00 and formula displays =SUM()

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - AUTO SUM function returns 0.00 and formula displays =SUM() (https://www.excelbanter.com/new-users-excel/116871-auto-sum-function-returns-0-00-formula-displays-%3Dsum.html)

UpTheCreek

AUTO SUM function returns 0.00 and formula displays =SUM()

After selecting a range of cells to sum, when I select the AUTO SUM function
it returns "=SUM()" in the last cell selected.

gls858

AUTO SUM function returns 0.00 and formula displays =SUM()

UpTheCreek wrote:
After selecting a range of cells to sum, when I select the AUTO SUM function
it returns "=SUM()" in the last cell selected.

Are the "numbers" actually numbers or are they formatted as text?

gls858

All times are GMT +1. The time now is 06:56 PM.