Spreadsheet: 220192d1363094719-countif-w-2-criteria-on-drop-downs-aghazali-file
Sheet: Sheet1

Column1 | Column2
Complete | Yes
Complete | Yes |  |  | I would like to count all that have [NAME] filled in as either "[NAME]" or "In Progress" as well as column2 blank.
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
NA | Yes
NA | Yes
Complete | Yes
NA | No
NA | No
In Progress
In Progress
NA | No
Complete | No
Complete | No
Complete | Yes
Complete | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | Yes
Complete | Yes
Complete | Yes
NA | No
Complete | Yes
NA | No
NA | No
NA | No
NA | No
Complete | Yes
NA | No
Complete | Yes
Complete | Yes
Complete | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | Yes
Complete | Yes
Complete | Yes
NA | No
NA | No
Complete | Yes
NA | No
Complete | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | Yes
In Progress
Complete | Yes
In Progress
Complete | Yes
Complete | Yes
Complete | Yes
In Progress
Complete | Yes
 | No
 | No
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | Yes
Complete
Complete
Complete
NA | No
NA | No
NA | No
NA | No
In Progress
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
In Progress | Yes
Complete | Yes
Complete | Yes
Complete | Yes
In Progress
In Progress
In Progress
Complete | Yes
NA | No
Not Started
In Progress
Complete | Yes
In Progress | Yes
Complete | Yes
In Progress | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
NA | No
NA | No
NA | No
Complete | Yes
NA | No
NA | No
NA | No
Complete | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
 | No
NA | No
NA | No
Complete | Yes
Complete | Yes
NA | No
Complete | Yes
Complete | Yes
NA | No
NA | No
NA | No
NA | No
In Progress
NA | No
NA | No
Complete | Yes
NA | No
NA | No
Complete | Yes
 | Yes
NA | No
NA | No
Complete | Yes
Complete | Yes
NA | No
 | Yes
NA | No
In Progress
NA | No
NA | No
NA | No
NA | No
In Progress
Complete
Complete
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
In Progress
NA | No
NA | No
In Progress
In Progress
In Progress
In Progress
In Progress
In Progress
In Progress
In Progress
In Progress
In Progress
NA | Yes
NA | No
Complete | Yes
Complete | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
 | No
NA | No
NA | No
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
Complete | Yes
NA | No
In Progress
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | No
Complete
Complete
NA | No
In Progress | Yes
In Progress | Yes
NA | No
NA | No
Complete | Yes
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
In Progress
In Progress
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | Yes
Complete | Yes
NA | No
NA | No
NA | No
NA | No
In Progress
NA | No
NA | No
In Progress
NA | No
In Progress | Yes
Complete | Yes
NA | No
NA | No
Complete | Yes
NA | No
In Progress
In Progress
NA | No
In Progress
In Progress
In Progress
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
NA | No
Complete | Yes