| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
worksheet adds 1 or 2 values to totals
EXCEL 2002
When I set up a sum formula, the program adds 1 value to the total. I am trying to duplicate a Lotus worksheet and the sums do not agree (SOME are off 1 value, but not all are off). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
worksheet adds 1 or 2 values to totals
Some of the fields you are trying to sum may be formatted as text. Excel
doesn't count these when using the SUM() function. Try this: Copy an Empty Cell Select the range you are trying to sum Paste Special-Add This will force Excel to convert all to numerical values, if this is in fact the problem. -- Regards, Dave "UnhappyC" wrote: EXCEL 2002 When I set up a sum formula, the program adds 1 value to the total. I am trying to duplicate a Lotus worksheet and the sums do not agree (SOME are off 1 value, but not all are off). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i know that my worksheet having repeated same values | Excel Worksheet Functions | |||
| Regarding updating 1000 values using vlookup from another worksheet | Excel Worksheet Functions | |||
| Find two values in worksheet to return one value | Excel Worksheet Functions | |||
| How do I bring totals from one worksheet onto the second worksheet | Excel Worksheet Functions | |||
| Transferring date from multiple worksheets to a "totals" worksheet. | Excel Discussion (Misc queries) | |||
Hybrid Mode
