Forum Discussion

Klaasw9's avatar
Klaasw9
Copper Contributor
Apr 21, 2022
Solved

Countif in countifs

Hi all,   I have a question about using a countif within a countifs-formula. I want to guarantee some kind of anonymity, therefore I only want to calculate the percentage if at least 10 persons ar...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Apr 21, 2022

    Klaasw9 

    Perhaps

     

    =IF(COUNTIF(N:N;1)>9;COUNTIFS(K:K;1;N:N;1)/COUNTIFS(K:K;">0";K:K;"<6";N:N;1);"")

HansVogelaar's avatar
HansVogelaar
MVP
Apr 21, 2022

Klaasw9 

Perhaps

 

=IF(COUNTIF(N:N;1)>9;COUNTIFS(K:K;1;N:N;1)/COUNTIFS(K:K;">0";K:K;"<6";N:N;1);"")

  • Klaasw9's avatar
    Klaasw9
    Copper Contributor
    Apr 22, 2022
    Thank you for the quick solution, this works great!

Resources