Thread: Countblank formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rodrigo Ferreira Rodrigo Ferreira is offline
external usenet poster
  
Posts: 79
Default Countblank formula
Try something like this:

SUMPRODUCT(--(A1:A10<""),--(B1:B10=""))

--

Rodrigo Ferreira


"EElliott" escreveu na mensagem
...
How can I count the number of blank cells in one column using the criteria
that cells another column is not blank?


Reply With QuoteReply With Quote