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.
|