SUMPRODUCT(1 COUNTIF(A1:A6,A1:A6))