sum problem excel 03

[wynand]

I have two workbooks with the same sheet1.
Columns (k1:k634) contain the same transaction amounts (k1 is heading).
both columns' format are set to number with two decimals.
there are about four empty cells in the range
formula used is: =sum(k2:k634)
when I sum these columns two totally different values are returned?
how do I know which total is the correct total?

please help!

 

[Bob Phillips]

Give an example.

 

[wynand]

thank you, sorted

Give an example.

--
__________________________________
HTH

Bob