Function : Sum Incorrectly from other worksheet !

  • Thread starter Thread starter eric
  • Start date Start date
E

eric

Please help..I have sheet A & B. I have a series of number
in sheet A which is refer to sheet B .When i sum the
number in sheet A, the answer was wrong. This worried me
as i frequently using the above method to do my progress
report. Please help me to solve the problem and if
possible, the reason for the fault.

Thanks!
 
eric said:
Please help..I have sheet A & B. I have a series of number
in sheet A which is refer to sheet B .When i sum the
number in sheet A, the answer was wrong. This worried me
as i frequently using the above method to do my progress
report. Please help me to solve the problem and if
possible, the reason for the fault.

Thanks!
Click to expand...

A likely possibility is that some of your 'numbers' are not true numbers but
text strings.
Suppose your numbers were in A1:A10. You can test using this formula in
(say) B1:
=ISTEXT(A1)
copied down as far as B10.
If some of the numbers are text, you can solve the problem by copying a
blank cell (formatted as general or number but not text), then selecting all
the 'numbers' and using
Edit > Paste Special > Operation, multiply
 
Hi

If some of the numbers are text, you can solve the problem by copying a
blank cell (formatted as general or number but not text), then selecting all
the 'numbers' and using
Edit > Paste Special > Operation, multiply
Click to expand...


It'll be better to use Add operation instead of Multiply, or insert 1 into
blank cell before copying, to avoid some confusion afterwards :-))


Arvi Laanemets
 
Back
Top