Thread: countif
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
  
Posts: 258
Default countif
so, something like this array formula:
=SUM(IF(A1:A10=1,IF(B1:B10="",1,0),0))

Regards,
Ivan

Reply With QuoteReply With Quote