Answers for "excel count cells with that contain text"

excel count number of cells not containing specific text

=COUNTIF(B2:B18,"<>*txt*")
this will give you a count of the number of cells that do not contain "txt"

excel count cells containing specific text

# Count cells containing specific text, ie "a" in "B4:B7":
=SUM(--(MMULT(--(B4:B7="a");TRANSPOSE(COLUMN(B4:B7)))>0))