Multiple if statement based on some conditions

[antexity]

See attached sample.

I am trying to automate the status of the test script. These are the scenarios that I am after:

All based if there is text in each row between B6:B99 (if any row between B6:B99 contains no value, then don't look at column E for that row)
Column E will have Data Validation Drop down with either Pass or Fail.
- If E6:E99 contains "Pass" and each row where there is a value in column B has "Pass" then C1 = "Pass"
- If E6:E99 contains "Pass" and some are blank (never finished the testing) then C1 = "Incomplete"
- If E6:E99 contains any "Fail" and some are blank, or some are "Pass" etc then C1 = "Fail"
- If E6:E99 are all blank (testing hasn't started), then C1 = "Not Started"

I appreciate any help on this, thanks so much!

samplets.xlsx

[Bernie Deitrick]

In cell C1:

=IF(COUNTIF(E6:E99,"Pass")=COUNTA(B6:B99), "Pass",IF(COUNTIF(E6:E99,"<>")=0,"Not Started",IF(COUNTIF(E6:E99,"Fail")>0, "Fail","Incomplete")))

[antexity]

In cell C1:

=IF(COUNTIF(E6:E99,"Pass")=COUNTA(B6:B99), "Pass",IF(COUNTIF(E6:E99,"<>")=0,"Not Started",IF(COUNTIF(E6:E99,"Fail")>0, "Fail","Incomplete")))

100% perfect. Thank you so much for your quick response. I left you a rep.

Thank you!