Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: SUM function limits?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Columbia, SC
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a spreadsheet that uses the SUM function in a lot of cells. These some functions add numbers for quite a few cells. I have found that if I enter more than 30 cells in the SUM function I get an formula error message. It goes away when I reduce back down to 30 cells. Is there indeed a limitation and if so how can I get around it?

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Are all the cells that you want to sum non-consecutive as in:

    =SUM(A1,A7,A23)?

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Assuming you cells are non-contiguous you could do one of 2 things.

    1. Use formula like:
    =Sum(A1,A10,B20,C25)+Sum(A100,K25,L56) etc

    2. Select, say a group of 10 cells while holding down the Ctrl key and then name each group. Eg "MyRange1" "MyRange2" etc then use
    =Sum(MyRange1,MyRange2,MyRange3)




  4. #4
    New Member
    Join Date
    Aug 2013
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SUM function limits?

    Quote Originally Posted by Dave Hawley View Post
    Assuming you cells are non-contiguous you could do one of 2 things.

    1. Use formula like:
    =Sum(A1,A10,B20,C25)+Sum(A100,K25,L56) etc

    2. Select, say a group of 10 cells while holding down the Ctrl key and then name each group. Eg "MyRange1" "MyRange2" etc then use
    =Sum(MyRange1,MyRange2,MyRange3)

    Nice! it Helps Me! Two Thumbs Up!

  5. #5
    Board Regular Drrellik's Avatar
    Join Date
    Apr 2013
    Location
    East Coast, South Carolina
    Posts
    717
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: SUM function limits?

    1846 views?? never minds I see the 2002 date

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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