Summations in excel for Mac

Question

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

hansvogelaar · Answer

RalphWegeicloudcom&nbsp;
Perhaps the last columns contain text values that look like numbers? Are they left-aligned if you set the Horizontal Alignment to General?

ralphwegeicloudcom · Answer

HansVogelaar&nbsp;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.&nbsp;

ralphwegeicloudcom · Answer

It is not sensitive to various settings of alignment.

hansvogelaar · Answer

RalphWegeicloudcom&nbsp;
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?

ralphwegeicloudcom · Answer

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&amp;rlkey=35b7i63cdmm0cx7iahrlu01ai

Forum Discussion

Summations in excel for Mac

7 Replies

Resources