A B C
1 breakfast $13.50
2 water $1.10
3 food $80.00
4 others $13.90
5 food $4

Is it possible to type an equation whereby it will scan A1:C5 and if
the word "food" is found it will add the number next to it? I can't
seems to use IF(logic_test, true value,false value) for this... pls
help


--
Lewis Koh
------------------------------------------------------------------------
Lewis Koh's Profile: http://www.excelforum.com/member.php...o&userid=25712
View this thread: http://www.excelforum.com/showthread...hreadid=391279