Answers for "excel count number of cells containing a letter"

excel count how many times a character appears in a cell

=LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))

Posted by: Guest on July-06-2021

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))

Posted by: Guest on March-18-2021

Code answers related to "excel count number of cells containing a letter"