=SUMPRODUCT(--($A$2:$A$100="Main"),--($B$2:$B$100="Yes"))

Joe wrote:
help I am trying to write a formula that says the following.

if coloum a = main and if coloum b = yes please count the yes's

I have tried using vlookup and count if but I just get a null value returned

hope there is somebody there who can help

thanks