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