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 |
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 |
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 |
All times are GMT +1. The time now is 07:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com