Weighted Average Ignoring Errors

Welcome to the forum.

I have to admit I'm not following exactly what it is you're doing. However, I can help you fix what you have in CC right now. There are two problems with the formula you have there.

1.
Don't surround the word TRUE with quotation marks - replace all the "TRUE" with just TRUE.

2.
The formulae in CD:CJ, as you obviously know, are giving errors. You can fix these by using AGGREGATE instead of just adding the cells together. For example, in CJ4 you have this:
=((BB4+BE4+BH4+BK4+BN4+BQ4+BT4)/(BA4+BD4+BG4+BJ4+BM4+BP4+BS4))
Replace it with this:

Formula:

Please Login or Register  to view this content.

You can also remove the inner brackets round the cells references if you want - it gives the same result:

Formula:

Please Login or Register  to view this content.

Apply the same principle to columns CD:CI.


How it works
Aggregate is a way of using other types of functions with certain 'ignore' criteria. The format is:
AGGREGATE ( function number , options to ignore , array or references )
Function number 9 is SUM
Option number 6 is 'ignore error values'

So the formula above means 'sum the first list of cells, ignoring any cells with errors and divide by the sum of the other list of cells also ignoring errors'.



I suspect there is probably a more elegant way of calculating CC, possibly without the helper columns, but my brain appears to be on a go slow today, sorry. At least the above will get you something which works for now.
Hope that helps a bit.