Get instant live expert help on count if cell contains
“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
need to count text in excel cell if it contains my test or not
Solved by G. Q. in 24 mins
Hi is there a formula I can use in SharePoint to count the amount of values in a cell. For example, count if cell contains text "Voice, Internet, TMB" the result of the formula would be 3
Solved by S. L. in 29 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