Thanks:  0
Likes:  0

1. 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. Are all the cells that you want to sum non-consecutive as in:

=SUM(A1,A7,A23)?

3. 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. ## Re: SUM function limits?

Originally Posted by Dave Hawley
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. ## Re: SUM function limits?

1846 views?? never minds I see the 2002 date

## User Tag List

#### Posting Permissions

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