I want to add more that 30 noncontiguous cells in Excel
 

I have a string of noncontiguous cells in excel that I need the total of, but
I can't enter more that 30 using the sum function

I want to add more that 30 noncontiguous cells in Excel
 

There are two easy solutions:

1. Cascade the sums - that is use more than one sum function.
2. Make your collection of disjoint cells into a name range

--
Gary''s Student - gsnu200793


"Egozite" wrote:

I have a string of noncontiguous cells in excel that I need the total of, but
I can't enter more that 30 using the sum function

I want to add more that 30 noncontiguous cells in Excel
 

On Wed, 18 Jun 2008 18:33:00 -0700, Egozite
wrote:

I have a string of noncontiguous cells in excel that I need the total of, but
I can't enter more that 30 using the sum function

You could use the addition operator:

=a1+b2+c3+d4+...f5:f10...+aa4+ab6...
--ron

I want to add more that 30 noncontiguous cells in Excel
 

You can also use multiple area references:

=SUM((A1,D2,H5,...Y57),(G127,J205,F23,...U2),(T1,T 5,T87,...T99))

The above formula contains 3 arguments. Each set of (...) is a single
argument.

--
Biff
Microsoft Excel MVP


"Egozite" wrote in message
...
I have a string of noncontiguous cells in excel that I need the total of,
but
I can't enter more that 30 using the sum function

I want to add more that 30 noncontiguous cells in Excel
 

I believe you could use just one argument w/multiple areas.
=SUM((A1,D2,H5,...Y57,G127,J205,F23,...U2,T1,T5,T8 7,...T99))


"T. Valko" wrote:

You can also use multiple area references:

=SUM((A1,D2,H5,...Y57),(G127,J205,F23,...U2),(T1,T 5,T87,...T99))

The above formula contains 3 arguments. Each set of (...) is a single
argument.

--
Biff
Microsoft Excel MVP


"Egozite" wrote in message
...
I have a string of noncontiguous cells in excel that I need the total of,
but
I can't enter more that 30 using the sum function

I want to add more that 30 noncontiguous cells in Excel
 

Yes, you could but I was demonstrating how it could be done wrt the number
of arguments.

--
Biff
Microsoft Excel MVP


"JMB" wrote in message
...
I believe you could use just one argument w/multiple areas.
=SUM((A1,D2,H5,...Y57,G127,J205,F23,...U2,T1,T5,T8 7,...T99))


"T. Valko" wrote:

You can also use multiple area references:

=SUM((A1,D2,H5,...Y57),(G127,J205,F23,...U2),(T1,T 5,T87,...T99))

The above formula contains 3 arguments. Each set of (...) is a single
argument.

--
Biff
Microsoft Excel MVP


"Egozite" wrote in message
...
I have a string of noncontiguous cells in excel that I need the total
of,
but
I can't enter more that 30 using the sum function