Originally Posted by gebobs

I'll dip my toe in again with a possible solution. If there's a more elegant one, perhaps xor knows it.

I don't think one can do AVERAGEIFS over multiple ranges. If so, then you would have to do it for each column of data and then combine. But averages of averages may not be accurate. This is definitely the case here since there are variable counts in the columns which would weight the percentages in columns with fewer counts greater than those with more.

Thus, the most accurate solution I can think of would be to go back to my earlier less elegant formula and expand it over the columns i.e. (sum of sums for each)/(sum of counts for each).



Without further ado, the formula from hell...