Get instant live expert help on I need help with excel countif unique

“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

I am getting a "0" return on my =COUNTIF feature. I am trying to get a count of unique text values within a given range, removing duplicates, using the formula =COUNTIF(A2:A138,B2), whereas the "B" column is the column containing only the unique text fields.
Solved by T. B. in 25 mins
I just want to find unique sales orders in below chart.Some sales orders are common for both work centers.=IF(A2=$E$1,(COUNTIF($B$2:B2,B2)=1)*1) This formula works.But after I select TR002 it missed common sales ordrs for TR001 & TR002 .How to find unique sales orders as 1 & Fales after I change workcenter using drop down. Excel Screen Shot
Solved by M. U. in 12 mins
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