 # Get instant live expert help on I need help with excel countif contains “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 column f contains "FT" AND column B does not contain a blank
Solved by G. W. in 20 mins
=countif(G5:G45, '< 100') returns an error and tries to modify the formulat to =countif(G5:G45, P16< 100'). Error says that apparently i'm not trying to type a formula, but I am. Column G contains a series of numbers, formatted as currency.
Solved by X. Y. in 22 mins
My formula contains an error that I can not resolve. I am trying to use the countif function to determine certain criteria without any success
Solved by V. E. in 23 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