nagje said:

Manual calculation over 11 months gives me: 95.84%[.]

The formula you gave me gives me 96.11%.

To exactly show you how the discrepancy occurs I would need not the

percentage values but the values used to compute the percentages. Take the

second figure 92.86. You are seeing only two decimal places. The actual

stored values could be 92.85999999999 or 92.863999999999999999999 or

any value in between

More to the point, what appears to be 92.86 could be as big as

92.8649...9 (enough 9s to fill 15 significant digits). But when I

append 49...9 to all of the OPs 11 numbers, the largest average is

still only 95.845909 -- not even close to 96.11.

On the other hand, I cannot duplicate the OP's claim that your formula

results in 96.11.

So I think the problem is not simply rounded displayed values v.

actual value, but the fact that the OP's numbers no longer match what

was posted earlier -- or the OP has a typo in the range that specified

for AVERAGE(), or the OP has misinterpreted what you suggested that

the OP do.

I suggest that the OP post the formulas that the OP is now using after

applying your suggestion.