Countif Else?

iroast · Jul 30, 2004

COUNTIF(A1:A10,"1") else COUNTIF(A1:A10,"2")? How do I make this work
Thanks again, all

Aladin Akyurek · Jul 30, 2004

If you mean to count 1's and 2's...

=SUM(COUNTIF(A1:A10,{1,2}))

=SUMPRODUCT((A1:A10=1)+(A1:A10=2))

Frank Kabel · Jul 30, 2004

Hi
and just another option :-)

=SUMPRODUCT(--(A1:A10={1,2}))