• Welcome to the new Mac-Forums. See News and Community Announcements for more details.

Numbers sum

749


Joined
May 28, 2020
Messages
10
Reaction score
0
Points
1
I go into Numbers and look at a spreadsheet. I highlight a column and expect to see a sum at the bottom. But its not there. I try hit =
and it only shows the sum of the first number on the top of the column.
How do I show sum....??Thats really the only thing I use in a spreadsheet anyway.... ridiculous..
 

Raz0rEdge

Well-known member
Staff member
Moderator
Joined
Jul 17, 2009
Messages
12,660
Reaction score
304
Points
83
Location
MA
Your Mac's Specs
2018 Mac-Mini macOS Catalina 10.15.5, 32 GB
Using Numbers 10.0 on Catalina. Selecting a column sums it all for me. Selecting a number of rows, sums only those rows.

Screen Shot 2020-06-01 at 5.24.51 PM.png

Screen Shot 2020-06-01 at 5.24.23 PM.png

Screen Shot 2020-06-01 at 5.24.29 PM.png
 

749


Joined
May 28, 2020
Messages
10
Reaction score
0
Points
1
I deleted Numbers and re installed it. Just to be sure. It still is not showing sum in the sum
box below. I would think the default set up would do that. Do I have a setting wrong.?
I highlight all the numbers in the column and hit return....but nothing. I do get the number of
entries/fields....that shows down below. but nothing else.... is there an alternative to Numbers that is free and good...?
 

krs


Joined
Sep 16, 2008
Messages
1,689
Reaction score
35
Points
48
Alternative would be Softmaker Free Office, but Numbers should work
 

Raz0rEdge

Well-known member
Staff member
Moderator
Joined
Jul 17, 2009
Messages
12,660
Reaction score
304
Points
83
Location
MA
Your Mac's Specs
2018 Mac-Mini macOS Catalina 10.15.5, 32 GB
You don't have to hit anything, just highlighting the rows should be enough or selecting the column. Show a screenshot of what you are seeing.
 
Joined
Jan 1, 2009
Messages
8,014
Reaction score
137
Points
63
Location
Winchester, VA
Your Mac's Specs
MBP 15" Mid 2015, iPhone 11 Pro, an iMac, plus ATVs, AWatch, MacMini
Are the "numbers" actually formatted as numbers and not text? You can check by selecting a cell or cells, then in the right column select "Cell" and make sure the "Data format" is something numeric and not something text.
 
Joined
Jul 6, 2008
Messages
784
Reaction score
30
Points
28
Are the "numbers" actually formatted as numbers and not text? You can check by selecting a cell or cells, then in the right column select "Cell" and make sure the "Data format" is something numeric and not something text.
^ Good point to double-check on, OP. This has gotten me more than once in Excel as well (usually when I've copied/pasted some "numbers").
 
Top