Dear Sirs,
Please refer to my attached sheet formula in YELLOW HIGHLIGHT for "Completed Score" is not working. Please help me out on this.
Thanks in advance..!!
Nitin Kumar
Dear Sirs,
Please refer to my attached sheet formula in YELLOW HIGHLIGHT for "Completed Score" is not working. Please help me out on this.
Thanks in advance..!!
Nitin Kumar
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
Click the * to say thanks.
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
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?
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)
Bookmarks