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

Thanks for the repsonse. No triangle. (I'm a MOUS Master Instructor so know
about looking for the obvious.) Its just a simple : =sum(H205:H208) but
doesn't want to work.



"Farhad" wrote:

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.