Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculate Passrate (CountIf)

Hello everyone, I looked around at what's already asked, but it doesn't really work for me. =COUNTIF([column1],">84.99")/COUNTIF([column1],"*") The above is my Excel formula, and what I'm trying...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

 

You should use a combination of CALCULATE, COUNT & FILTER, as below:

 

CALCULATE(
COUNTROWS(evaluations),
FILTER(evaluations, [column1] > 84.99)
) 
/ 
COUNTROWS(evaluations)

 

Hope that helps

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks! The data is slightly different than before, so let me double check before I mark it as a solution haha.