=SUMIF(A2:A8,"yes",B2:B8)
will sum the values in B2:B8 if the text in A2:A8 is yes.

Hope this helps.
--
John C


"forevercali" wrote:

It is a simple yes/no question.. Can i use the sum if function with text? Or
am i stuck with Look up?

Thanks