Two-way matrix lookup to find word 'ERROR' & read value from that row/column

[joeyyb94]

Hi Guys

Hope I explain this well enough for you to be able to support :-)

I am trying to enter a formula in column K (xOOT) where excel looks along row 5 ($L$5-$XX$5), and every time it gets to the word 'ERROR' it looks down the column to see if there is a value in the cell for that corresponding row, if yes it counts it as 1, if not it just assumes it to be 0.

For example, I have tried to demonstrate in my attachment what the values should be for this snippet of the spreadsheet.

I have had some success with MAXIF functions but cannot seem to get the COUNTIF function to work.

Hoping you can provide some assistance!

JB