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