Sum Function with wrong total shown
=SUM((D18:D22),+(F18:F22),+(H18:H22))
Hi. I think this should do it...
=SUM(D18:D22, F18:F22, H18:H22)
--
HTH :)
Dana DeLouis
Reluctantly using Excel 2007
"TDLambert" wrote in message
...
Hi
Can anyone help. When I enter this formula
=SUM((D18:D22),+(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?
--
TDLambert
|