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...
So far I came up with this formula. Note that the range is a lot bigger, but the idea is exactly the same.
=COUNTA(($D$12:$D$211)-COUNTIF($D$12:$D$211,"=0"))/COUNTA($D$12:$D$211,"P")
However, the result stays 0.50% regardless of how many P's and/ or A's I have filled out.
I think I'm using a wrong operator somewhere....