Without a array

=SUMPRODUCT(--(B2:B6={"A","B","C"}))
VBA Noob