View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Newbie problem: numbers with +positive and -negative indicators

=A1+A2+A3

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

".Net Sports" wrote in message
...
I have a column of numbers that i need to have a positive or negative
indicator to add up with the AutoSum function,

+3
-3.5
+10

....but can't get the autosum function on the row below to
calculate...i get an empty " =sum( ) " display; what is the correct
way to format these numbers so i can get the total of +9.5 with this
column