“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Hi, I need a sumif formula using a criteria that represents "is not equal to a certain cell value (is a text value), what's the syntax for this criteria?

Solved by Z. Y. in 23 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

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 am trying to count numbers in a column if they are less than or equal to a value in C20. It works when I do "=" but not when I combine with less than. What am I doing wrong? =COUNTIF($H$26:$H$67,"<="&C20)

Solved by V. D. in 23 mins