View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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.