SUM function limits?

hbendillo · Mar 4th, 2002, 03:43 PM

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?

Aladin Akyurek · Mar 4th, 2002, 03:56 PM

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

=SUM(A1,A7,A23)?

Dave Hawley · Mar 4th, 2002, 05:32 PM

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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 03:43 PM	#1
hbendillo Board Regular Join Date: Mar 2002 Location: Columbia, SC Posts: 81	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?

Mar 4th, 2002, 03:56 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	Are all the cells that you want to sum non-consecutive as in: =SUM(A1,A7,A23)?

Mar 4th, 2002, 05:32 PM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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)