Posted by nrthshgrlYou could use COUNTIFFor example:=COUNTIF(B1:B3,"A")would give you the number of As in the range B1 to B3