Hi Jeff,
As I feared, there's a lot I don't understand about the code. What does "x" do in the line that sets sFormula? The With thing is a mystery to me, even though I found some examples of its use on the net. Why is .Value set to itself? I forgot to mention one important point. Columns ending in "1" are weighted, meaning that the calls therein get 2 points. Calls in columns ending in "2" get 1 point. So, the value that COUNTIF has for a given call in columns B, F, J, N, and Q should be multiplied by 2. I can't determine whether this can be done where sFormula is set or within the With statement. Again, thanks very much for your help. This will make my job much easier.
Don
|