# Countifs formula not working with multiple cells

1. ## Countifs formula not working with multiple cells

Dear Sirs,

Nitin Kumar  Register To Reply

2. ## Re: Countifs formula not working with multiple cells

Based on your formula i would go with something like:
=SUMPRODUCT((\$C\$11:\$C\$22=\$P\$11)*(\$D\$11:\$I\$22=\$O\$11))*Q11+SUMPRODUCT((\$C\$11:\$C\$22=\$P\$12)*(\$D\$11:\$I\$22=\$O\$11))*\$Q\$12+SUMPRODUCT((\$C\$11:\$C\$22=\$P\$13)*(\$D\$11:\$I\$22=\$O\$11))*\$Q\$13  Register To Reply

3. ## Re: Countifs formula not working with multiple cells

Dear Sir,

Thanks a lot for your prompt concern; the formula which you suggested is giving value more than Total Score which is 40 and completed score comes to 240 whwich is incorrect . Request please review.

Nitin  Register To Reply

4. ## Re: Countifs formula not working with multiple cells

Well, you did not had a desired result. I assumed that you needed to count the completed for each Lane and for each priority, then multiply them by the weightage. If this is not the case, then what logic should apply?  Register To Reply

5. ## Re: Countifs formula not working with multiple cells

well yes right formula is right as per logic i need to multiply Total Score by total number of lanes
Thanks o lot..!!  Register To Reply