Formual help needed

[Guest]

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

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A20="me"),C2:C20)-SUMPRODUCT((A2:A20="me")*(B2:B20={"green
","orange","bean","apple","bananas","corn"})*C2:C20)

--

HTH

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

 

[Domenic]

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,D16,0))),C1:C100)

....where D16 contains your list of items to exclude, such as green,
orange, etc.

Hope this helps!