You have to add a separate summation for that column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lewis Koh" wrote
in message ...

Lewis Koh Wrote:

A B C D E
1 breakfast $13.50 food $5
2 water $1.10 Shirt $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

Hmm...=sumif(B1:B5,"Food",C1:C5) can't work if food appears on another
column. Is there a way to work around this?


--
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