Get instant live expert help on count if cell contains any text

“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 need to count a cell that contains a certain text but omit the text that contains the same text but with extra. For example, I want to count a cell that contains "HM2" but I don't want to count the cell that contains "HM21". Please help, been stuck for so long.
Solved by T. W. in 15 mins
I want to have Cell B6 Increase in number from cell B5 by one if cell contains text Can you assist please
Solved by G. L. in 12 mins
need to count text in excel cell if it contains my test or not
Solved by G. Q. in 24 mins
I NEED A GOOGLE SHEET FORMULA TO USE AN IF FUNCTION FOR EXAMPLE IF A CELL CONTAIN S ANY TEXT AT ALL THEN ANOTHER CELL POPULATES A NUMBER AND IF THE NEXT CELL IN THE SEQUENCE CONTAINS ANY TEXT AT ALL IT WILL THE SAME NUMBER AGAIN IF ANY CELL IS BLANK IT ENTERS NOTHING AND JUST LEAVES THE OTHER CELL BLANK
Solved by O. C. in 11 mins
I want to create a formula that checks Cells H8:H14, and count if cell contains text, if yes then adds 1 and if no then it adds 0 to the total count which is in cell J15... So essentially, J14=0+1+1+1 and so on so forth, adding one to the total if the corresponding cell contains text, and adding 0 to the total if the corresponding cell does not contain text...
Solved by Z. Y. in 16 mins