Hi,

You have four possibilities, so my recommendation is :
cell F1 type Pass
cell G1 type Fail
cell E2 type Quarter
cell E3 type Half

Then in cell F2 type following formula :
=SUMPRODUCT(--($B$1:$B$3=$E2),--($C$1:$C$3=F$1))

Then copy this formula to cell G2, F3 and G3

HTH