If these "groups" are determined by their common value in another column,
then perhaps the Data SubTotals feature would serve you .

hth
Vaya con Dios,
Chuck, CABGx3



"FIRSTROUNDKO via OfficeKB.com" wrote:

Hi!

How do I sum the ranges in A1 to A8 so this example becomes

1
5
4

1
4

7

becomes this

1
5
4

10

1
4

5

7

7

Thanks in advance

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200612/1