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
Perhaps the last columns contain text values that look like numbers? Are they left-aligned if you set the Horizontal Alignment to General?
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=35b7i63cdmm0cx7iahrlu01ai