worksheet adds 1 or 2 values to totals

U

UnhappyC

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

David Billigmeier

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