Multiple vlookup and adding values together

[oddball1405]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am trying to find a way to locate all categories in a table that says for ex "good." Each of these have a number associated to them which I am trying to add together.

So lets say my table has ten rows of data, three of those rows have a column that is termed "good." So what I want that to do is then take those three rows with "good" and add the numeric values together that are entered in another column which are each of those three rows.

Is this even possible?

 

[CyberTaz]

I don't believe you'll need VLOOKUP() for this. Have a look at SUMIF()
instead.

 

[oddball1405]

Thank you CyberTaz that was exactly what I was looking for.