ADD DIFFERENT RANGES OF CELLS

  • Thread starter Add non continuous ranges of cells
  • Start date
A

Add non continuous 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
 
R

Ragdyer

<<<"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)
 
I

Ivan F Moala

You can also enter =Sum(

and just press and hold the 'ctrl' key and select the desired range to
sum??
 
A

Add non continuous ranges of cells

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

Add non continuous ranges of cells

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.
 
Top