ExcelBanter - Sum Function with wrong total shown

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum Function with wrong total shown (https://www.excelbanter.com/excel-worksheet-functions/142289-sum-function-wrong-total-shown.html)

TDLambert

Sum Function with wrong total shown

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

Mike H

Sum Function with wrong total shown

Take out the + signs.

Mike

"TDLambert" wrote:

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

Dana DeLouis

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

All times are GMT +1. The time now is 12:41 PM.