Is there a way in excel to go through each row and add a certain cell if
it meets a certain condition in an adjacent cell?

for example

Item Quantity Price

Pin 5 20
Tag 8 40
Pin 3 15
Tag 2 10
Tag 1 7

I want to add up all the prices if the item is a pin


--
Jrr6415sun
------------------------------------------------------------------------
Jrr6415sun's Profile: http://www.excelforum.com/member.php...o&userid=25064
View this thread: http://www.excelforum.com/showthread...hreadid=385838