Try this:
=SUMIF(A:A,"Pin",C:C)
OR
Enter the item to lookup in another cell (D1), for easy revision:
=SUMIF(A:A,D1,C:C)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Jrr6415sun" wrote
in message ...
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