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