how can I add degrees? ie 300degrees + 100 degrees = 40 degrees

[Bablefish]

I want to add magnetic headings. I need to enter the degrees as 3 figures. ie
045
I have found that I can do that when I add the degree sybmol to the figure.
But when I try to use the sum command, it wont add because the field
contains the symbol.

 

[Bob Phillips]

=SUMPRODUCT(--SUBSTITUTE(A1:A3,"x",""))

replace the x with your degree symbol

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gary''s Student]

Use custom formatting:

000°

Use this for both the values and the sums. The degree symbol is in the
formatting, not the cell.