Formula not adding corectly

Copper Contributor

=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...

2 Replies


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,