Thread: Count the non blank cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Count the non blank cells
=SUMPRODUCT(--(I1:I14<""),--(J1:J14="a"))

How to count the non blank cells in a column (COLUMN I) corresponding with certain
criteria in an adjacent column (COLUMN J) .

Regards,
Stefi
Reply With QuoteReply With Quote