Try SUMIF:
http://www.officearticles.com/excel/...ft_excel.h tm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Bradley Bell" wrote in message
...
Hi,

I am fairly new to excel and have a problem that I have been trying to
solve on my own for days without any luck. Any help will be greatly
appreciated...

I would like to extract values from a column (column D) in a spreadsheet
where the text (column B) in a different column of the spreadsheet matches
a certain criteria in the numerous rows and have the results of these
values added up and the answer placed in a cell...

Thank you kindly in advance,

Bradley Bell,