I am trying to write a formula to calculate the following:
How many rows contain "bruteforce" in column A and "Pass" in the column where row A contains "build three"?
Now, I have gotten somewhat close to this. This formula will give the total number of cells containing 'PASS' in the column in which row 1 contains "build three":
=COUNTIF(OFFSET(D2:Z3500, 0, MATCH("build three", D1:F1)-1, 3499,1), "Pass")
However, I don't know where to go from here. An additional requirement is to avoid any VBA.