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!”
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