Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct - checking for multiple options in one column
Hi,
I am trying to create a formula which will tell me how many projects I have which meet certain criteria and I am having trouble setting up my formula to look for multiple options in one column. At the moment I have SUMPRODUCT(--($A2$A100={"Criteria 1a","Criteria 1b"}),--($B2$B100="Criteria 2"),--($C2$C100="Criteria 3")) but it doesnt work! Could one of you good people help me out!? Thanks Ed |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct - checking for multiple options in one column
Try it like this:
=SUMPRODUCT(--(($A2:$A100="Criteria 1a")+($A2:$A100="Criteria 1b")),--($B2:$B100="Criteria 2"),--($C2:$C100="Criteria 3")) HTH Elkar "edeaston" wrote: Hi, I am trying to create a formula which will tell me how many projects I have which meet certain criteria and I am having trouble setting up my formula to look for multiple options in one column. At the moment I have SUMPRODUCT(--($A2$A100={"Criteria 1a","Criteria 1b"}),--($B2$B100="Criteria 2"),--($C2$C100="Criteria 3")) but it doesnt work! Could one of you good people help me out!? Thanks Ed |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct - checking for multiple options in one column
Works perfectly - thanks
Ed "Elkar" wrote: Try it like this: =SUMPRODUCT(--(($A2:$A100="Criteria 1a")+($A2:$A100="Criteria 1b")),--($B2:$B100="Criteria 2"),--($C2:$C100="Criteria 3")) HTH Elkar "edeaston" wrote: Hi, I am trying to create a formula which will tell me how many projects I have which meet certain criteria and I am having trouble setting up my formula to look for multiple options in one column. At the moment I have SUMPRODUCT(--($A2$A100={"Criteria 1a","Criteria 1b"}),--($B2$B100="Criteria 2"),--($C2$C100="Criteria 3")) but it doesnt work! Could one of you good people help me out!? Thanks Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ProtectSheet Options are un-checking after macro | Excel Discussion (Misc queries) | |||
Are Error-Checking rules (in Excel Options) workbook-specific? | Excel Discussion (Misc queries) | |||
Error Checking Options - 2000-2003 | Excel Discussion (Misc queries) | |||
Sumproduct checking between two dates | Excel Worksheet Functions | |||
spell checking options | Excel Worksheet Functions |