Forum Discussion
Calculate Percentage of cell range of cells with value
Hello, I wish to calculate the percentage of a range of cells (column), but only if they have a value other than '0' (some lazy conditional formatting on my part). It pertains to calculating stud...
Do you mean that one "p" is equal to 10%? if there are 9ps then the percentage should be 90%? if yes then we can solve this problem with the help of countif function.
This formula can be used:
=COUNTIF(F6:F26,"p")*10&"%"
the answer will be in this case 70%.
=COUNTIF(F6:F26,"p")*10&"%"
the answer will be in this case 70%.
- The formula works well, but only on 10 classes.
If my next class the student is Present, the rate will go to 90%, and if the student were to attend all classes, the attendance rate would be 200%.
So if I have 11 classes and the student attended 8, the result should become 73% (rounded).
Does that make sense?
