Hi JBeaucaire,

Thanks for your response. I should have been more clear. On each tab, I have a formula in a separate cell that calculates a score. So on the master tab, that score is calculated based on the values for all of the clients. If I just sort so I can only see Peter's clients, the formula doesn't change and it still has all of the other values included in its calculation.

That's why I have them on separate tabs. I have a cell with the score on Peter's tab and so on and so forth. But as you said, I may be working too hard. Maybe there's a way that the formula can reflect the values that show when a filter is applied? That would be much easier.

Here is the formula I have to calculate the score: =ROUNDUP((100*((COUNTIF(A:A,">8")-COUNTIF(A:A,"<7"))/COUNT(A:A))),0)