If the number of items you are attempting to track is small and based on your
example for the items in Column A and Column B, try the following formulas in
the following cells on your worksheet.

Place this formula in A9
=IF((SUMPRODUCT(($A$2:$A$7="Paint")*$B$2:$B$7)0), "Paint"," ")
Place this formula in B9
=IF(A9="Paint",SUMPRODUCT(($A$2:$A$7="Paint")*$B$2 :$B$7),"")
Place this formula in A10
=IF((SUMPRODUCT(($A$2:$A$7="Thinner")*$B$2:$B$7)0 ),"Thinner"," ")
Place this formula in B10
=IF(A10="Thinner",SUMPRODUCT(($A$2:$A$7="Thinner") *$B$2:$B$7),"")

I think you see the pattern now, so you should know how to create the
formula for Caulk.


"lintan" wrote:

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.