“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

need to count text in excel cell if it contains my test or not

Solved by G. Q. in 24 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

I need a formula to count cells containing a specific text, only if another column contains a specific amount

Solved by B. Q. in 16 mins

If cell A1 contains value "xyz", I want cell A2 to require text be entered by user.
If cell A1 contains anything other than "xyz", I don't need text entered into cell A2.
How do I do this?

Solved by C. H. in 20 mins