Forum Discussion
SUM is not adding up in one cell, but it works on the copied cell
So if you look in my screenshots, cell AC10 has got the function in the correct cell. But it's saying the sum is 0. which makes the other two 0. When I copied it to the cellar AC11 through AC26, they...
Perhaps D10:AB10 are text values, even though they look like numbers?
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?