Newbie problem: numbers with +positive and -negative indicators
On Oct 2, 7:43 am, "RagDyeR" wrote:
=A1+A2+A3
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
Thanks for the responses.... the problem I have is, I need to add
these numbers in this column just like they are and have +9.5 as the
result (i'm using Office2003 version) and it won't let me autosum it
even when i remove the plus signs on the positive numbers, it just
spits out an "=sum()" where the +3 cell is.... I need to add these
like they are positive and negative numbers; how do I go into Format
Cells to do this????
".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
|