Summing non contiguous cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sum 44 non contiguous cells. But after I do about 30, it no
longer allows me to select them. Is this something in Excel 2003? A setting I
can change?
 
Try creating four 10-cell non-contiguious RangeNames.....(hold down Ctrl
while selecting the cells).........then SUM them by RangeName

=SUM(Range1,Range2,Range3,Range4)

Vaya con Dios,
Chuck, CABGx3
 
Millie said:
I am trying to sum 44 non contiguous cells. But after I do about 30,
it no longer allows me to select them. Is this something in Excel
2003? A setting I can change?
Click to expand...


There's no setting to change: it's a limitation of a Excel.

Instead of using a SUM function you can use the "+" operator, or you can
break your SUM into two SUM:

=SUM(arg1,arg2, ... ,arg30)+SUM(arg31,arg32, ... ,arg44)

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Millie

Add an extra pair of parens.

=SUM((A1,A3,A4 up to 44 cells))


Gord Dibben MS Excel MVP
 
If there is a *pattern* to those non-contiguous cells, such as every second,
or third, or tenth, or whatever, post back and let us know what it might be,
so that a formula might be suggested where typing those cells in
individually wouldn't be necessary.
 
Back
Top