Remember Me?

#1
June 16th 05, 10:41 PM
 Jan Posts: n/a
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

#2
June 16th 05, 10:59 PM
 Bob Phillips Posts: n/a

=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

#3
June 16th 05, 11:30 PM
 Domenic Posts: n/a

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!

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Dan W. Excel Worksheet Functions 19 March 6th 08 09:08 AM Jan Excel Worksheet Functions 1 June 16th 05 11:28 PM Darrell New Users to Excel 6 May 5th 05 10:25 PM Ian Harris Excel Worksheet Functions 3 December 3rd 04 02:04 PM Ian Harris Excel Worksheet Functions 2 December 3rd 04 11:36 AM

All times are GMT +1. The time now is 05:08 AM.