LostNFound wrote:
Is this counting the "yes" only with "1" in column A! Is it looking for both
criterias?
I had eight ones in column A and one yes were there was a one and it
returned 12.5% it should have returned 88%
What did I do wrong??
"Bob Phillips" wrote:
=SUMPRODUCT(--(A1:A100=1),--(D1:D100="yes"))/COUNTIF(A1:A100,1)
will give the percentage
Replace the "yes" bit with just "".
|