....and yet another way
{=SUM(IF($A$1:$A$11="N",IF($B$1:$B$11=4,1,IF($B$1: $B$11=5,1,0))))}