View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default =sum not working

Hi,

Is there a green teriangle in the left top corner of the cells that your
numbers are in them? if not please write your sum formula.

Thanks,
--
Farhad Hodjat


"SLP" wrote:

Hello. I am trying to do an =sum for 205 rows. The result is 0. I checked
Tools | Otpions -- Automatic is set. The cells leading into the =sum are
formatted as numbers. (Also tried it with General). The cells that lead into
those cells are not text. Any ideas on what is wrong? Thanks.