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

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