Using LARGE on calculated numbers

[mactoolsix]

I've run into this problem before, but never figured a way around the problem.

I have a column list of 40 numbers. Each number is the result of a calculation. Each cell is formulated as "number."

I want the average of the ten largest numbers.
I use the formula =AVERAGE(LARGE(B1:B40,({1,2,3,4,5,6,7,8,9,10}))) which returns a number smaller than any one number in the list.

If I copy the list to a different place (i.e. B45=B1 and drag it down), then enter the same formula, I get the correct answer.

It be something to do with the original list of numbers being calculated?

Thanks,
Mike

 

[yellow_orange]

the formula you entered is okay but you did not lock the range B1:B40
if you copy or drag the formula, the range will also change. you can consider locking the range (i.e., $B$1:$B$40)

you can share a sample file and specify what you want to achieve. and provide your expected output or formula result

 

[mactoolsix]

I simply made B45=B1 then I drag that down. The result is the numbers match exactly, and of course I changed the formula to match the new cells (B45:b85).
Sorry I don't have a "simple" file to share - it's about a dozen tabs long with hundreds of calculations.