ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   auto sum will not work (https://www.excelbanter.com/new-users-excel/248126-auto-sum-will-not-work.html)

Soshagayle

auto sum will not work
 
I am new.. I did the tutorials.. I have a new spread sheet and I can not get
the auto sum to work. I highlight my column and hit auto sum and it gives me
a formula but no total. I pushed enter but I can not figure this out. I'm a
dummy.
Please help me.

T. Valko

auto sum will not work
 
Sounds like the cell if formatted as TEXT. Change the cells format to
GENERAL then hit function key F2 then hit Enter.

--
Biff
Microsoft Excel MVP


"Soshagayle" wrote in message
...
I am new.. I did the tutorials.. I have a new spread sheet and I can not
get
the auto sum to work. I highlight my column and hit auto sum and it gives
me
a formula but no total. I pushed enter but I can not figure this out.
I'm a
dummy.
Please help me.




Eduardo

auto sum will not work
 
Hi,
If you can see the formula but not the result, in excel 2007 go to Formulas
in the menu, then under formula auditing 3rd block, click on Show Formulas

"Soshagayle" wrote:

I am new.. I did the tutorials.. I have a new spread sheet and I can not get
the auto sum to work. I highlight my column and hit auto sum and it gives me
a formula but no total. I pushed enter but I can not figure this out. I'm a
dummy.
Please help me.



All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com