Thread: How do I use countif like sumif ie (range,criteria,count_range)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default How do I use countif like sumif ie (range,criteria,count_range)
Your question is not entirely clear, but I think you may be looking for
this...

=SUMPRODUCT((A1:A10=A40)*(C1:C10<""))

--
Rick (MVP - Excel)


"tmarie" wrote in message
...
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

Reply With QuoteReply With Quote