worksheet adds 1 or 2 values to totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Totalling sequential worksheets 1
Add Values that Match 2 Criteria Q 1
Copy formula from one worksheet to another to get value in 2nd wks 1
Linking Totals Across Multiple Worksheets 2
Changing Sum Range Based on Date Chosen from Drop Down List 1
Transfering a changing cell value progressively through a workbook 3
Conditional Sum across WORKSHEET 6

Back
Top