Re: Excel Question
[ 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.
|