| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct i think
Hello,
I'm struggling with what I think requires a sumproduct function but I can't make it work and I'm going cross eyed... I need to count the number of occurences of "x" in column c if the value in column a = "text1" or "text2" but column b < "text3". -- Any help appreciated, MarkN |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct i think
Hi Mark
Try the below =SUMPRODUCT((ISNUMBER(MATCH(A1:A10,{"text1","text2 "},0)))*(B1:B10<"text3")*(C1:C10="x")) If this post helps click Yes --------------- Jacob Skaria "MarkN" wrote: Hello, I'm struggling with what I think requires a sumproduct function but I can't make it work and I'm going cross eyed... I need to count the number of occurences of "x" in column c if the value in column a = "text1" or "text2" but column b < "text3". -- Any help appreciated, MarkN |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct i think
Try this...
=SUMPRODUCT(--(ISNUMBER(MATCH(A2:A20,{"text1","text2"},0))),--(B2:B20<"text3"),--(C2:C20="x")) -- Biff Microsoft Excel MVP "MarkN" wrote in message ... Hello, I'm struggling with what I think requires a sumproduct function but I can't make it work and I'm going cross eyed... I need to count the number of occurences of "x" in column c if the value in column a = "text1" or "text2" but column b < "text3". -- Any help appreciated, MarkN |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct i think
Thanks very much Jacob,
Not only for the prompt reply but it works a treat. -- Thanks, MarkN "Jacob Skaria" wrote: Hi Mark Try the below =SUMPRODUCT((ISNUMBER(MATCH(A1:A10,{"text1","text2 "},0)))*(B1:B10<"text3")*(C1:C10="x")) If this post helps click Yes --------------- Jacob Skaria "MarkN" wrote: Hello, I'm struggling with what I think requires a sumproduct function but I can't make it work and I'm going cross eyed... I need to count the number of occurences of "x" in column c if the value in column a = "text1" or "text2" but column b < "text3". -- Any help appreciated, MarkN |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| SUMPRODUCT, or something else entirely? | Excel Discussion (Misc queries) | |||
| using sumproduct | Excel Worksheet Functions | |||
Linear Mode
