hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION

Marty · Nov 11, 2004

I am trying to count 2 different values that could be in a cell. Is it
possible to do that with the COUNTIF function? If so, what is the syntax?

Thanks.

Frank Kabel · Nov 11, 2004

Hi
try
=SUM(COUNTIF(A1:A100,{"value1","value2"}))

hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION

Marty

Frank Kabel