Formula not adding corectly
=SUM(CU6+CW6+CY6+DA6+DC6+DE6) not returning the correct value to the target cell where the source cells all contain numerical values, i.e. 2, 6, 2.5...
Forum Discussion
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Quite many possible reasons
- in source cells could be shown some rounded values
- insource cells could be texts which looks numbers,
etc.
