Another way...

=SUMPRODUCT(--(A1:A100="me"),--(ISNA(MATCH(B1:B100,{"green","orange","bea
n","apple","bananas","corn"},0))),C1:C100)

OR

=SUMPRODUCT(--(A1:A100="me"),--(ISNA(MATCH(B1:B100,D1:D6,0))),C1:C100)

....where D1:D6 contains your list of items to exclude, such as green,
orange, etc.

Hope this helps!

In article ,
Jan wrote:

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