Sorry but it does not make any sence for me, coutif(a1:a10,a40) should return
the same result as it:

=sumproduct(--(a1:a10=a40)*(c1:c10<""))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"tmarie" escreveu:

I need to count cells with values by reference to a range in the same way
that sumif sums them ie countif(a1:a10,a40,c1:c10)
This doesn't work but I'm hoping there's another way?

cheers
thanks