Hello:

I have a list from From B2:F25 of items and amounts.

B2 C2 D3 D4 E2 F2
Plastic 1 Metal 3 Stone 4
Wood 2 Plastic 1
Wood 1 Plastic 2 Metal 1

I would like to total in a cell the total amount of plastic in the whole
chart. The total should be 4 not the amount of times the word plastic appears
in the chart. I need the total amount of plastic ordered.

Thanks for any help.

Art.