Assuming the items are in columns B, D and F and the numbers are in columns
C, E and G.

A1 = plastic

=SUMIF(B2:F25,A1,C2:G25)

--
Biff
Microsoft Excel MVP


"art" wrote in message
...
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.