Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
=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
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time format help needed | Excel Worksheet Functions | |||
Formual help needed | Excel Worksheet Functions | |||
formula needed | New Users to Excel | |||
If Statement help needed please | Excel Worksheet Functions | |||
If statement help needed | Excel Worksheet Functions |