[Keats13]

Try (for A, for example)

=sum((i$1:i$6=m2)*(k$1:k$6="No")*j$1:j$6)

Then hit CTRL+SHIFT+ENTER (not just enter)

(The $ are not necessary, but enable you to copy & paste with ease.)