AboutPricing

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

“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.
< Go Back

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

    countif = b1 or b1 example countifs(a:a,b1 or b2)
    Solved by A. U. in 30 mins
    pivot table with chart using countif yes or no from column and total count
    Solved by K. H. in 17 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