Newbie problem: numbers with +positive and -negative indicators
That's because you don't have numbers, you have text. Autosum can't add
text. It adds numbers.
First, change your entries to numbers. Second, use a custom format of
+General;-General;0 to display numbers with signs.
Regards,
Fred.
".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
|