How do I use countif like sumif ie (range,criteria,count_range)

  • Thread starter Thread starter tmarie
  • Start date Start date
T

tmarie

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
 
Back
Top