I'm not sure if I'm using the right function, but I have a row of test
results and some cells have the option for a "pass/fail" result (not a number
or a grade).

I want to summarise the results from each section of the test, so am adding
the scores quite happily. However, if one of the questions is failed, this
needs to be shown in the summary.

I have tried to use Lookup but it won't display "Fail" in a cell on the
summary.

Any help would be greatly appreciated.

Thanks