SumProduct - checking for multiple options in one column

E

edeaston

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
 
E

Elkar

Try it like this:

=SUMPRODUCT(--(($A2:$A100="Criteria 1a")+($A2:$A100="Criteria
1b")),--($B2:$B100="Criteria 2"),--($C2:$C100="Criteria 3"))

HTH
Elkar
 
E

edeaston

Works perfectly - thanks

Ed

Elkar said:
Try it like this:

=SUMPRODUCT(--(($A2:$A100="Criteria 1a")+($A2:$A100="Criteria
1b")),--($B2:$B100="Criteria 2"),--($C2:$C100="Criteria 3"))

HTH
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top