Thread: COUNTIF with 2 columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J.A.1975 J.A.1975 is offline
external usenet poster
  
Posts: 2
Default COUNTIF with 2 columns
Hi, how do I count cells in A with nothing in B.

A B
x
x 2011/02/17
2011/03/21
x
x 2011/04/11
x

=COUNTIF(A:A;"x") but not counting when date (B:B) is available (it
means it did arrive)

Best regards,
Alberto
Reply With QuoteReply With Quote