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).

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).