Auto Sum reporting 0 as total...

  • Thread starter Thread starter Jeremy
  • Start date Start date
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.
 
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'
 
Back
Top