count many with COUNTIF?
 

Is there a way of doing this:
=COUNTIF(A1:A200;C2:C15)
without having to
=COUNTIF(A1:A200;C2)+COUNTIF(A1:A200;C3)+ ... ?

with best regards

P.S.
For those using a non-english Excel -- such as I (me?) -- translations of
functions in 9 languages: cherbe.free.fr/traduc_fonctions_xl97.html

count many with COUNTIF?
 

Try this:

=SUMPRODUCT(COUNTIF(A1:A200,C2:C15))

Biff

"Bob" wrote in message
...
Is there a way of doing this:
=COUNTIF(A1:A200;C2:C15)
without having to
=COUNTIF(A1:A200;C2)+COUNTIF(A1:A200;C3)+ ... ?

with best regards

P.S.
For those using a non-english Excel -- such as I (me?) -- translations of
functions in 9 languages: cherbe.free.fr/traduc_fonctions_xl97.html

count many with COUNTIF?
 

Thank you, but no, that didn't work; I get the wrong result "0". Although I'm
not quite sure what Excel is counting...
What I want to count is strings (if that is complicating everything), i.e
'how many' of this, that and the other in A1:A200; "this, that and the other"
is specifyed in C2:C15.

This ought to be possible, one might think...

Bob

count many with COUNTIF?
 

I retract my answer!!! It does work, human error...

Thank you very much Biff!!

Bob

"Bob" skrev:

Thank you, but no, that didn't work; I get the wrong result "0". Although I'm
not quite sure what Excel is counting...
What I want to count is strings (if that is complicating everything), i.e
'how many' of this, that and the other in A1:A200; "this, that and the other"
is specifyed in C2:C15.

This ought to be possible, one might think...

Bob

count many with COUNTIF?
 

I was concerned after reading your first reply but I feel better now!

You're welcome. Thanks for the feedback!

Biff

"Bob" wrote in message
...
I retract my answer!!! It does work, human error...

Thank you very much Biff!!

Bob

"Bob" skrev:

Thank you, but no, that didn't work; I get the wrong result "0". Although
I'm
not quite sure what Excel is counting...
What I want to count is strings (if that is complicating everything), i.e
'how many' of this, that and the other in A1:A200; "this, that and the
other"
is specifyed in C2:C15.

This ought to be possible, one might think...

Bob