A
acw
Frank
If you just want to count the number of yes or no, then
=COUNTIF(B2:B10,"yes") or =COUNTIF(B2:B10,"no") will
suffice.
However, if you want to match the name and action try the
SUMPRODUCT.
=SUMPRODUCT(($A$2:$A$10=A2)*($B$2:$B$10="yes")) will count
for the yes.
Tony
If you just want to count the number of yes or no, then
=COUNTIF(B2:B10,"yes") or =COUNTIF(B2:B10,"no") will
suffice.
However, if you want to match the name and action try the
SUMPRODUCT.
=SUMPRODUCT(($A$2:$A$10=A2)*($B$2:$B$10="yes")) will count
for the yes.
Tony