View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wilson Wilson is offline
external usenet poster
 
Posts: 18
Default Advanced Apology

I've been searching the internet for the past 1.5 days and have yet to find
an example of the formula I'm looking for.... so if this is easy, I apologize
in advance.

I want a count of the number of cells where column "I" values = "NA" and
column "D" values = "0". In the example below, only the 2nd & 5th rows would
meet the criteria.

I D
NA 5
NA 0
xx/xx/xx 0
xx/xx/xx 0
NA 0
xx/xx/xx 7
NA 3