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

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