I have tried and searched, but my brains cannot solve the following:

I try to describe here, but it is easier to see in the attachment xls. I tried to make a array formula in single cell for the issues as attached. I want to count the occurrence of "NG" in this example, but the values to count are in different columns. the column to pick are listed in the first column. There is no issues in doing this in two steps as attached, but how to do this in a single cell,....aaarrcchh.

is there a way to do this counting in a single array cell?

Many thanks in advance

Bart