Counting # of WOs in Excel meeting specific criteria
I need a formula for Column F of attached sample spreadsheet based on the following conditions:
If following conditions are met:
Col A is not blank, and the number is unique (format of number is always "yyyy-#######")
Col B does not contain the text string "amd" or "AMD"
Col D is not blank
Col E is not blank, and does not contain "N/A"
Column F (COUNT_WO) = 1
If the above conditions are not met, then:
Column F (COUNT_WO) = 0