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

U

UpTheCreek

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

gls858

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

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

gls858
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Please help with last formula for order form. 1
The sum of the same function that is used for a range of cells 2
A useful AVERAGE calculation without using the built-in AVERAGE function 3
dragging formulas acros adjacent cells 3
Excel 2013: AutoFilter and SUM() 1
Sum a variable length column 1
Newbie Help - IF Yes No Function 0

Top