Most use the SumProduct(). Some recommend multiplying by 1 in that formula. I have not seen a case where it made a difference though.
In a third method that is more complicate:
{=SUM((IF(LEFT(A2:A9,9)="10.36.12.", IF(B2:B9="Pass",1,0),0)))}
Range names should be ok.
In a 4th method:
You...