Countif in countifs

New Contributor

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!




Thank you in advance for thinking along!

2 Replies
best response confirmed by Klaasw9 (New Contributor)





Thank you for the quick solution, this works great!