Forum Discussion
Summations in excel for Mac
I have a workbook with ten columns to add the totals on. Summation works on six of them and I only get a zero on the remainder. How do I get it to add the numbers in the last three colu
Thanks, Hans. No text in there and it is not sensitive to alignment. What is strange is that it worked on the first six columns. I have only used 31 KB it shouldn't be a memory issue.
It is not sensitive to various settings of alignment.
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?
- This is one of the ten sections os the spreadsheet. The earlier ones work fine.
https://www.dropbox.com/scl/fi/6bs6qga6x6jf3696cfu5g/Spread-Bike-Sample.xlsx?dl=0&rlkey=35b7i63cdmm0cx7iahrlu01aiThanks. You have circular references: the formula in K3 is =SUM(B3:K3), so the formula refers to the cell itself. This prevents Excel from recalculating. Change the formula in K3 to =SUM(B3:J3), then fill down to K93.
The sum in K95 will then be calculated correctly.
