Summary of Production

[Pete]

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

 

[IanRoy]

Hi, Pete;
Perhaps I don't understand the problem, but SUMIF looks like it would work
there.
Specifically:
=SUMIF(R$5:R$9,A1,Y$5:Y$9)+SUMIF(R$22:R$26,A1,Y$22:Y$26)+SUMIF(R$39:R$43,A1,Y$39:Y$43)
in column B and fill on down where A:A is your product list and B:B is to
contain your summary amounts.
Regards,
Ian.

 

[Earl Kiosterud]

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