# Get instant live expert help on if countif excel

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

=+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
hi, i have this formula which is bringing back false on certain cells, i want to remove the false please =IF(COUNTIF(\$F\$3:\$F\$80000,\$F3)>1,IF(COUNTIF(\$G\$3:\$G\$80000,\$G3)>1,IF(COUNTIF(\$O\$3:\$O\$80000,\$O3)>1,"Duplicate","")))
Solved by K. B. in 12 mins
Need help in countif formuls if values are same
Solved by Z. A. in 23 mins
i am new at excel want to understand countif function
Solved by Z. H. in 16 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