Forum Discussion
RalphWegeicloudcom
Jan 15, 2023Copper Contributor
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
7 Replies
Perhaps the last columns contain text values that look like numbers? Are they left-aligned if you set the Horizontal Alignment to General?
- RalphWegeicloudcomCopper Contributor
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.
- RalphWegeicloudcomCopper ContributorIt is not sensitive to various settings of alignment.