Get instant live Excel expert help with a COUNTIF Functions

“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'm trying to do a countif statement, where it will pick up the name and date for each month, only think is its in date format eg 01/04/2017
Solved by Z. C. in 28 mins
COUNTIF($BN$22:$BN$38,"<>"&"*") how this formula working
Solved by E. U. in 27 mins
Im doing a countif on values in a column, but am only getting a value returned of 0 which is ticking the first box. But I am wanting to get a more specific value back like 0 Backup Issues... is this possible?
Solved by K. L. in 20 mins
I've been trying to use the COUNTIF function to extract the number of occurrences of a particular word CONTAINED in a bunch of cells by referencing an outside cell. It works fine if I enter the search parameters manually like this: =COUNTIF(B2:B443,"*wabigoon*") but instead of entering 'Wabigoon' or something else, I want to reference a cell that contains the word Wabigoon or whatever other word I wish to search. Any thoughts?
Solved by E. Y. in 27 mins
How can I use the COUNTIF formula to count a range of numbers as single occurrences?
Solved by M. C. in 18 mins
Need help using a formula (I think countif) to evaluate a range of cells and calculate an up/down the ladder sum compared against the other cells
Solved by S. H. in 18 mins
I am trying to conditionally format a cell (J225) based on if the SUM of a range divided by the COUNTIF of a range is less then 7.5.
Solved by V. L. in 22 mins
Trying to get columns (not cells, not rows) to do this formula countif(K1:K,"Yes") Worked fine when the expert did it but now won't work on my database. What am I doing wrong, or do I have wrong version of excel. CSV data was then saved as excel workseet.
Solved by X. H. in 11 mins
Need a formula to countif the contents of BC (in words) = the contents of BE (in words). I tried countif(BC:BC=BE:BE,1,0) but this does not work. thank you.
Solved by F. Q. in 21 mins
hello I have a countif formula for multiple cells but do not want to manually type in each cell number is there any way to get them to auto populate for example =COUNTIF('15Nov'!$C$4:$C$4,"x")+COUNTIF('15Nov'!$C$4:$C$4,"x") =COUNTIF('15Nov'!$C$5:$C$5,"x")+COUNTIF('15Nov'!$C$5:$C$5,"x") =COUNTIF('15Nov'!$C$6:$C$6,"x")+COUNTIF('15Nov'!$C$6:$C$6,"x") and so on?
Solved by X. W. in 29 mins