Excel Question

[bravos1]

[ QUOTE ]
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.)

[/ QUOTE ]

OR you can just put this formula in N2 and drag it down

=SUMPRODUCT(--($I$1:$I$6=$M2),--($K$1:$K$6="No"),$J$1:$J$6)

If you want to count a yes instead, then just change No to Yes.

These 2 are basically the same except I used SUMPRODUCT where keats just used SUM, but "manually" added the product by multiplying.