Hi,
Can someone help me with putting up formulas for cells O12:O14 in "Summary" sheet. I would want to know how many got 90% and above for O12, 85% to 89.99% for O13, and 84.99% in O14.
Thanks!
Hi,
Can someone help me with putting up formulas for cells O12:O14 in "Summary" sheet. I would want to know how many got 90% and above for O12, 85% to 89.99% for O13, and 84.99% in O14.
Thanks!
In O12:
Formula:Please Login or Register to view this content.
In O13 (and filled down to O14):
Formula:Please Login or Register to view this content.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
worked great, thank you!
I think that there are more problems with your sheet than you may realise. On yur sheet, as posted, the overall passing rate was 8%. That can't be correct. There was only one set of scores, which passed, so it can ONLY have been 100%.
All of the yellow shaded cells have been amended. Only when a candidate ID number is entered will the cells populate.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks