ADD DIFFERENT RANGES OF CELLS

I need to perform a sum of many (over 100) different cells and ranges that
are not in a continuous range. I could use the = function which would take
forever, and the sum function does not work when I try to add different
ranges that are not in a continuous order.

I know there is a simple way to do this...can anyone help - please?

Example: let's say I have these numbers in different cells
1,2,3,4,5,6,7,8,etc... and I want to add the cells that have the numbers
2,4,5 and 8. How can I add them without using the = or the sum function

<<<"and the sum function does not work when I try to add different ranges
that are not in a continuous order">>>

That is *not* true!

This works fine:

=SUM(A5:A10,D5:H5,H6,A20,C12:F18)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Add non continuous ranges of cells" <Add non continuous ranges of
[email protected]> wrote in message
news:[email protected]...
> I need to perform a sum of many (over 100) different cells and ranges that
> are not in a continuous range. I could use the = function which would
take
> forever, and the sum function does not work when I try to add different
> ranges that are not in a continuous order.
>
> I know there is a simple way to do this...can anyone help - please?
>
> Example: let's say I have these numbers in different cells
> 1,2,3,4,5,6,7,8,etc... and I want to add the cells that have the numbers
> 2,4,5 and 8. How can I add them without using the = or the sum function
>

Thanks, THIS HELPS ME SOOOO MUCH. I guess I kept forgetting to put a COMMA
between the different ranges....

"Ragdyer" wrote:

> <<<"and the sum function does not work when I try to add different ranges
> that are not in a continuous order">>>
>
> That is *not* true!
>
> This works fine:
>
> =SUM(A5:A10,D5:H5,H6,A20,C12:F18)
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Add non continuous ranges of cells" <Add non continuous ranges of
> [email protected]> wrote in message
> news:[email protected]...
> > I need to perform a sum of many (over 100) different cells and ranges that
> > are not in a continuous range. I could use the = function which would
> take
> > forever, and the sum function does not work when I try to add different
> > ranges that are not in a continuous order.
> >
> > I know there is a simple way to do this...can anyone help - please?
> >
> > Example: let's say I have these numbers in different cells
> > 1,2,3,4,5,6,7,8,etc... and I want to add the cells that have the numbers
> > 2,4,5 and 8. How can I add them without using the = or the sum function
> >
>
>

Thanks Ivan, both methods work....I always tried to do this, but did not
realize that I needed to put a comma after each range that I selected.

"Ivan F Moala" wrote:

>
> You can also enter =Sum(
>
> and just press and hold the 'ctrl' key and select the desired range to
> sum??
>
>
> --
> Ivan F Moala
>
>
> ------------------------------------------------------------------------
> Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954
> View this thread: http://www.excelforum.com/showthread...hreadid=554232
>
>