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

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