Hello,

I have a matrix of numeric values 13 by 7 cells.

If I summarize the horizontal figures (13 columns in total) it gives me a total.

If I do the same (different purpose) for the vertical (7 rows in total) it also gives me a total.

No formatting. except 2 digits behind comma.

I thought the total of the 13 columns would be the same as the total of the 7 rows.

I learned that Excel calculates through 15 digits behind the comma.

But I find that the total of the 7 rows it calculates to 14 digits behind the comma, the 15th digit is forgotten(?). The total of the 13 columns also loses its 15th digit behind the comma.

That would make is even, but no horizontal total of columns is NOT EQUAL TO vertical total of rows.

Please explain or help to get it accurate.

On request, I can supply the matrix to describe my calculation error further.

Kind regards Eddy  

​Hello,I have a matrix of numeric values 13 by 7 cells.If I summarize the horizontal figures (13 columns in total) it gives me a total.If I do the same (different purpose) for the vertical (7 rows in total) it also gives me a total.No formatting. except 2 digits behind comma.I thought the total of the 13 columns would be the same as the total of the 7 rows.I learned that Excel calculates through 15 digits behind the comma.But I find that the total of the 7 rows it calculates to 14 digits behind the comma, the 15th digit is forgotten(?). The total of the 13 columns also loses its 15th digit behind the comma.That would make is even, but no horizontal total of columns is NOT EQUAL TO vertical total of rows.Please explain or help to get it accurate. On request, I can supply the matrix to describe my calculation error further. Kind regards Eddy     Read More

​