Countif in countifs

[Klaasw9]

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 are part of a specific category. The red part in the formula below is not working, so I am wondering if something else might fix this problem for me! Because I have to do this for a lot of percentages I want to fix it in the formula!

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

Thank you in advance for thinking along!

[#2 · Accepted solution]

@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);"")

[#3]

Thank you for the quick solution, this works great!