Hey,

Having trouble figuring this out: (excel 2013)

I have 2 sheets (we'll call them Sheet1 & sheet2)
Sheet1: Cells A1:A10 will contain the following string: "pass", "fail" or blank
From sheet2 Cell: B1 I want to check if the cells A1:A10(in sheet1) all have the value string "pass" or blank. If True then value in cell B1 be "passed" otherwise "failed"

It seems that Excel can't check for strings in cell range across sheets...
Though i did manage to do it manually (e.g. sheet1.A1, sheet1.A2 Sheet1.A3)
this is my manual version: =IF(AND((sheet1!A1="pass"),(1!A2="pass"),(sheet1!A3="pass")),"passed","failed")

Any suggestions?