Thanks so much for your help. What I mean by the second part is that the repair orders per advisor will vary every day. So in the example pic, I would use =countif(D1:D2, "x")/2 to get their percentage for that day. But if they have three repair orders the next day, I have to change the range to include the third cell. I don't know how to avoid this. Is there formula that when only count the X's in column D only if they are in the same row as advisor 1?