# Countifs formula not working with multiple cells

Dear Sirs,

Nitin Kumar

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

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

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?

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..!!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1