| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My autosum total is incorrect - what is wrong? | Excel Discussion (Misc queries) | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| total and subtotal positions wrong in excel | Excel Discussion (Misc queries) | |||
| Pivot Table Grand Total wrong when using Formulas | Excel Discussion (Misc queries) | |||
| Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Linear Mode
