boll55,
I'm sorry to say that I can't answer the question you are asking - I'll look into it when I get the chance - hopefully by then someone else will come to your rescue.
However, I will offer one suggestion.... on sheet 1 (2), in cells E37:AB37, you have an incredibly long formula trying to do something that a simple short formula could handle much more gracefully.... your formula in E37 is this:
When you could simply use this:
The " -COUNTBLANK(E11:E29) " portion removes the count of blank cells from the sum of correct matches. You can paste the formula above in cells E37 thru AB37.
Cheers,
Vince
Bookmarks