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