Forum Discussion
Excel Formula help
I have made an excel tracking document to track learners exams and assessments. I have set cell to turn colour depending on the percentage they achieved. What I would like to happen if the pass crite...
Hi Adam
The issue is with merged cells and numbers in the cells between,
you can sort it by the formula in the conditional formatting please see attached file
=SUM(COUNTIFS($B3:$S3,">=0.6",$B3:$S3,"<1"),COUNTIF($B3:$S3,"Pass"),COUNTIF($B3:$S3,"RPL"))=9
Thanks Tomas that is great and does the job perfectly. I don suppose if you have time to briefly explain what the formula means as i would love to learn how it works and be able to adapt this code to work with other tracking documents.
Adam