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

Attached Files

forum example 10 col norun.xlsm (17.4 KB, 11 views)