Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 16th 05, 10:41 PM
Jan
 
Posts: n/a
Default 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   Report Post  
Old June 16th 05, 10:59 PM
Bob Phillips
 
Posts: n/a
Default

=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   Report Post  
Old June 16th 05, 11:30 PM
Domenic
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017