“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

i am new at excel want to understand countif function

Solved by Z. H. in 16 mins

=IFERROR((SUM(AI17))/(((COUNTIF(H12:AF12,"9")+ COUNTIF(H12:AF12,"6")+ COUNTIF(H12:AF12,"3"))*9)+((COUNTIF(H12:AF13,"9")+ COUNTIF(H13:AF13,"6")+ COUNTIF(H13:AF13,"3"))*9)+((COUNTIF(H14:AF14,"9")+ COUNTIF(H14:AF14,"6")+ COUNTIF(H14:AF14,"3"))*9)+((COUNTIF(H15:AF15,"9")+ COUNTIF(H15:AF15,"6")+ COUNTIF(H15:AF15,"3"))*9)),"")=0% IT SHOULD BE 100% WERE AM I MESSING UP?

Solved by Z. Y. in 16 mins

=+COUNTIF(AC710:BG710,"*am*")+COUNTIF(AC710:BG710,"*pm*")+COUNTIF(AC710:BG710,"*audit*")-COUNTIF(AC710:BG710,"*redo*")-COUNTIF(AC710:BG710,"*pre-training*")
when I use this formula, Excel won't accept it but does not say there is an error in it.
If I change the ranges to search from AD : BG, then it works. Any idea why?

Solved by G. H. in 14 mins

I need help using the countif function
The formula =countif(B104:M133,>=0.11) does not work and excel is highlighting M133 as the problem

Solved by B. W. in 22 mins

I need to be able to count certain letters as numbers and then add them all up
=((COUNTIF(P19:P28,"A")*12),(COUNTIF(P19:P28,"B")*12),(COUNTIF(P19:P28,"C")*8),(COUNTIF(P19:P28,"D")*8),(COUNTIF(P19:P28,"E")*12),(COUNTIF(P19:P28,"F")*8),(COUNTIF(P19:P28,"G")*12),(COUNTIF(P19:P28,"H")*8),(COUNTIF(P19:P28,"I")*12)) this is what I was trying to use

Solved by V. F. in 24 mins