Sum Function with wrong total shown

[Guest]

Hi

Can anyone help. When I enter this formula
=SUM((D1822),+(F18:F22),+(H18:H22)) the end result is 7000. In using
Insert/Function the Function Arrguments box shows the Formula result = 15000
which correct.
Why does 7000 show?

 

[Guest]

Take out the + signs.

Mike

 

[Dana DeLouis]

=SUM((D1822),+(F18:F22),+(H18:H22))

Hi. I think this should do it...
=SUM(D1822, F18:F22, H18:H22)