Text and Sum

[Jonsson]

Hi Gord,

It works fine writing text in B1, thank you!

Now, I've tried to write the text in A1, but then I get that ###value,
again.
Please explain how this formula works, so I can modify it as I want
to.
(In my version of excel I have to write ; instead of ,)

//Thomas

 

[Gord Dibben]

Jonsson

Not sure what you are trying to do.

A1 = thomas
B1 = thomas
C1 = 10

D1 =SUM(A1;B1;C1) will return 10

D1 =SUM(A1;-B1;C1) will cause an error

Just remember, SUM will ignore text but using an operator such as (-) or (+)
will throw an error.

e.g. -B1 will throw an error if B1 is thomas.

Your choice of combinations are unknown to me so can't do much more.

Gord