Text and Sum

[Jonsson]

Thanks, but I think I was explaining a little bit wrong.

Let´s say I have 4 columns A,B,C,D.

In A1 I have 5 in B1 Thomas, and in C1 10. In D I have th
formula:Sum(B1-A1-C1)

Then I think you also get ####, Yes?

Any ideas

 

[JulieD]

Hi Jonsson

ummm ... what are you trying to achieve with
=SUM(B1-A1-C1)
as you're actually saying, add up B1 minus A1 minus C1
however, if i do as you've outlined i get #VALUE and not #### in the cell.

Maybe letting us know what you expect to see as the result would assist
more.

Cheers
JulieD

 

[RagDyeR]

Does this work for you ?

=SUM(B1,-A1,-C1)
--

HTH,

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



Thanks, but I think I was explaining a little bit wrong.

Let´s say I have 4 columns A,B,C,D.

In A1 I have 5 in B1 Thomas, and in C1 10. In D I have the
formula:Sum(B1-A1-C1)

Then I think you also get ####, Yes?

Any ideas?