Summing non contiguous cells
 

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?

Summing non contiguous cells
 

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" wrote:

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?

Summing non contiguous cells
 

Millie wrote:
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

Summing non contiguous cells
 

Millie

Add an extra pair of parens.

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


Gord Dibben MS Excel MVP

On Thu, 10 Aug 2006 10:15:02 -0700, Millie
wrote:

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?

Summing non contiguous cells
 

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Millie" wrote in message
...
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?