View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tyson Porter Tyson Porter is offline
external usenet poster
 
Posts: 2
Default SUM formula not working

I trying to add a range of cells but I keep getting the Value of ZERO back.
Its a very basic formula:

=sum(e2:e908)

The value keeps coming up on the sheet as zero, yet when I go into the
Formula Audit area it shows the value as what it should be 4231.8 any ideas
why it keeps showing up as ZERO on the sheet? I have checked all my cell
formatting and its all set properly. I've used this same formula on previous
sheets with no problem.