I did post this earler, but don't see it listed. Sorry, if it is a duplicate
post.
I'm using Excel 2003.

I need a formula to do the following:

If column A = "me" and
column B < "green", "orange", "bean", "apple", "bananas" or corn" then
Sum column C.

TIA