Formual help needed
 

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

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

--

HTH

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


"Jan" wrote in message
...
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

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