Thread: How do I count nonblank cells that meet criteria in another cell?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic Domenic is offline
external usenet poster
  
Posts: 256
Default How do I count nonblank cells that meet criteria in another cell?
In article ,
jimswinder wrote:

Domenic:

Thanks that worked....

You're welcome!

what do I need to replace "x" with in the formula if I
want it to find ANY text (non blank cells)?

Try...

=SUM(IF(A2:A19=A1,IF(C2:C19<"",1,0)))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!
Reply With QuoteReply With Quote