Hi!

Create a new list that contains only the unique items from
the material list. You can do this by using an advanced
filter. Instructions he

http://contextures.com/xladvfilter01.html#FilterUR

Assume the new list is on Sheet1 starting in cell A1 and
the original data is on Sheet2 in the range A1:B10.

On Sheet1 cell B1 enter this formula and copy down as
needed:

=SUMIF(Sheet2!A$1:A$10,A1,Sheet2!B$1:B$10)

Biff

-----Original Message-----
Column A contains material name and Column B contains
usage. I would like to
choose the name and the total usage of materials that
were used. For
explanation purposes,

Column A Column B
Paint 30
Thinner 15
Paint 10
Thinner 5
Caulk 0

Therefore, the table will contain paint = 40 and thinner
= 20. Caulk will
not be displayed since it had zero usage.


.