what's the equivalent to the sumif formula for text??
Ie:

Food Drinks

pizza

pizza

I want to put in a new colum the result ONLY IF says Food, so the result in
this case would be pizza. I want a formula that looks for the word "Food" and
copy the row.