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.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Marty" schrieb im Newsbeitrag
...
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.