Summing non contiguous cells

[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?

 

[Guest]

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

 

[Franz Verga]

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?

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

 

[Gord Dibben]

Millie

Add an extra pair of parens.

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


Gord Dibben MS Excel MVP

 

[RagDyer]

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.