I want to be able to count the number of times text occurs in one column
based on a match with a different condition in the second column.
The formula: =SUM(IF{(A199:A216="Karratha",IF(B199:B206="DET",1 ,0)))}
returns #N/A when entered as an array and returns 1 when entered as normal.