Function : Sum Incorrectly from other worksheet !

[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!

 

[Anon]

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!

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

 

[Arvi Laanemets]

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

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