Pete,

A couple of possibilities.

1) Sort the table on column R. That should put all the like products
together. Now use Data - Subtotal. Instruct it to break ("at each change
in") on column R, and do a SUM (Use function), and do it to (add subtotal
to) column Y.

2) Make a pivot table, grouping on column R (drag into a row or column of
the pivot table), and using column Y for data (drag into the data area).
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Pete" wrote in message
...
I have 3 ranges

R5:R9
R22:R26
R39:R43

Is it possible to have a summary of products made in
these ranges e.g

R5="Product1" Y5=230
R6="Product2" Y6=250
R7="Product3" Y7=150

R22="Product4" Y22=100
R23="Product1" Y23=200
R24="Product2" Y24=150

R39="Product2" Y39=225
R40="Product5" Y40=125

Product1 = 430
Product2 = 625
Product3 = 150
Product4 = 100

There maybe days we don't make Product2 so I wouldn't
want to display that product. I know I can sumif, but I
only want to sum the values actually in the "R" ranges
above in the summary below.

hope this makes sense

Pete