Auto Sum reporting 0 as total...

J

Jeremy

I am trying to use the Auto Sum feature to total the
numbers in a couple of collumns but it keeps reporting 0.
Even if I manually type in the function, =sum(e2:e50), it
still reports 0. If I use the normal add syntax,
e2+e3+e4, it gives the correct total. I have checked the
cell format, copied to another workbook, nothing seems to
work. Any suggestions would be appreciated.
 
F

Frank Kabel

Hi
your numbers are probably stored as text. Try the following:
- select an empty cell and copy it
- select your numbers (E2:E50)
- goto 'Edit - Paste Special' and choose 'Add'
 

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

Top