Thread: Count the non blank cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vijaydsk1970 vijaydsk1970 is offline
external usenet poster
  
Posts: 47
Default Count the non blank cells
Thank you Stefi

"Stefi" wrote:

=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