Results 1 to 9 of 9

Thread: Numbers sum

  1. #1
    Numbers sum

    Member Since
    May 28, 2020
    Posts
    15
    Rep Power
    1
    Numbers sum
    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..

  2. #2
    Numbers sum
    Raz0rEdge's Avatar
    Member Since
    Jul 17, 2009
    Location
    MA
    Posts
    12,686
    Rep Power
    24
    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
    --
    Regards
    ...Ashwin


  3. #3
    Numbers sum

    Member Since
    May 28, 2020
    Posts
    15
    Rep Power
    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...?

  4. #4
    Numbers sum
    krs's Avatar
    Member Since
    Sep 16, 2008
    Posts
    1,720
    Rep Power
    12
    Alternative would be Softmaker Free Office, but Numbers should work

  5. #5
    Numbers sum
    Raz0rEdge's Avatar
    Member Since
    Jul 17, 2009
    Location
    MA
    Posts
    12,686
    Rep Power
    24
    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.
    --
    Regards
    ...Ashwin


  6. #6
    Numbers sum
    MacInWin's Avatar
    Member Since
    Jan 01, 2009
    Location
    Winchester, VA
    Posts
    8,042
    Your Mac's Specs
    MBP 15" Mid 2015, iPhone 11 Pro, an iMac, plus ATVs, AWatch, MacMini
    Rep Power
    31
    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.
    Jake

  7. #7
    Numbers sum
    usagora's Avatar
    Member Since
    Jul 06, 2008
    Posts
    859
    Rep Power
    14
    Quote Originally Posted by MacInWin View Post
    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").
    Jonathan
    2019 iMac (27"/i9/64GB) | 2012 iMac (27"/i5/16GB) | 2013 MacBook Air (13"/i5/4GB) | iPhone SE (2020) | Apple Watch Series 4

  8. #8
    Numbers sum

    Member Since
    May 28, 2020
    Posts
    15
    Rep Power
    1
    wrong file type. Cant do all types.

  9. #9
    Numbers sum
    usagora's Avatar
    Member Since
    Jul 06, 2008
    Posts
    859
    Rep Power
    14
    Quote Originally Posted by 749 View Post
    wrong file type. Cant do all types.
    Would you mind elaborating? What file format was the spreadsheet in?
    Jonathan
    2019 iMac (27"/i9/64GB) | 2012 iMac (27"/i5/16GB) | 2013 MacBook Air (13"/i5/4GB) | iPhone SE (2020) | Apple Watch Series 4

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Numbers 4.1.1 - page numbers
    By marcybacoo in forum Switcher Hangout
    Replies: 1
    Last Post: 05-13-2017, 03:34 PM
  2. Partial Sorting Numbers' spreadsheet using Numbers 3.6.1
    By Chipper279 in forum macOS - Apps and Games
    Replies: 1
    Last Post: 01-05-2016, 04:01 PM
  3. Need help with Numbers
    By ulansan in forum macOS - Apps and Games
    Replies: 0
    Last Post: 12-23-2014, 08:26 PM
  4. Replies: 0
    Last Post: 08-23-2011, 04:14 AM
  5. Correlating Model Numbers and Apple Part Numbers
    By fziksman in forum Other Hardware and Peripherals
    Replies: 0
    Last Post: 01-30-2007, 05:41 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •