Table that shows percentages for each person based on table

**thejoed82** · 05-28-2013, 10:21 AM

I need a formula in column I which will show the percentage of times "Yes" comes up in column C for each person in column A. In the current month on the sheet it's obviously going to be 100%, but in future months it could be different.May Photos.xlsx I'm doing this as a favor to someone, and just can't figure it out. If someone has some help for me it would be greatly appreciated.

**Andy Pope** · 05-28-2013, 10:42 AM

one way is to use SUMPRODUCT, formula in I2 and copied down.

=SUMPRODUCT(($A$2:$A$21=H2)*($C$2:$C$21="YES"))/COUNTA($A$2:$A$21)

**thejoed82** · 05-28-2013, 11:01 AM

Thanks Andy, that's really close to what I need, but my explanation was off. I don't need the percentages for the individual people. The percentages need to show what percent of times Yes shows up for each person. So, since Dave took all required photos for the three cases he was on, it would be 100%. If, in another month, he didn't take all required photos for one of his three cases, it needs to show 66%. I didn't explain it well the first time, I apologize.

**Andy Pope** · 05-28-2013, 11:09 AM

so the denominator for the formula also needs to be the result of a formula that counts the number of Dave's rather the count of records.

=SUMPRODUCT(($A$2:$A$21=H2)*($C$2:$C$21="YES"))/COUNTIF($A$2:$A$21,H2)