I have got an excel file in that sum function is not working, even if I copy the numbers to a new file the same thing happens, but if I input new numbers then sum function is working Can anyone tell me the issue?
1. Make sure there are no hidden Rows/Columns in your data area
2. Check that all the numbers are actually numbers and not text. Often numbers or tables copied off the web or even copied and pasted from Access are Text not numbers. Easiest way to fix is to paste a number 1 some where and copy it. Then paste special and Multiply as values