=Countif(range,"5")/countif((range,"*")*6)).

[Szaboteur]

Hello everyone,


I wish there is someone who can deblock myself from this situation:
I want to do this:


=Countif(range,"5")/countif((range,"*")*6)).


In natural language sounds like this for me:


Count in that range how many times you find a value. Be that 5 for exemple. After you found how many 5s are in that range, divide that by the output of this: count how many times you find text in a another range, and that value multiplied with 6.




Thank you a lot

 

[jtakw]

Double post and already answered: http://www.mrexcel.com/forum/excel-questions/939821-countif-divided-countif.html

 

[mole999]

please read the forum rules, ask clarifying questions in the original thread > http://www.mrexcel.com/forum/excel-questions/939821-countif-divided-countif.html
I am locking this thread