SUM of Non-Contiguous cells? Possible?

[Guest]

I'm trying to get a sum of non-contiguous cells in a column
= ((H7:H28) +(H37:H77) +(H82:H98))

Every way I try it, I get a #value error. I can applekey select the various
ranges, but the formula won't accept them.
Is there a way to do this?

Jeff
~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com

 

[Guest]

Nevermind. Stumbled onto answer

I'm trying to get a sum of non-contiguous cells in a column
= ((H7:H28) +(H37:H77) +(H82:H98))

Every way I try it, I get a #value error. I can applekey select the various
ranges, but the formula won't accept them.
Is there a way to do this?

Jeff
~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com

~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com

 

[JE McGimpsey]

one way:

=SUM(H7:H28,H37:H77,H82:H98)

another:

Select the cells in your noncontiguous range and name them (type a name,
say "myname" in the Name Box at the left of the Formula Bar). Then use

=SUM(myname)

 

[Guest]

Thanks for the alternate methods
Jeff

one way:

=SUM(H7:H28,H37:H77,H82:H98)

another:

Select the cells in your noncontiguous range and name them (type a name,
say "myname" in the Name Box at the left of the Formula Bar). Then use

=SUM(myname)

~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.com