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!”
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