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