Average Help, v. 2.0

[Matthew Dyer]

Thanks again for the help on my previous question. Now, using the same
beginning format, I'd like to know how to figure out what the average
for the remaining values needs to be to reach 5.

ex. Starting with 7 different values from A1 thru A7, what would the
values of A8 thru A10 have to be to reach an overall average of 5?

 

[Ch.Wolfram]

Hi Matthew!

answer:
assuming your values are in A1:A10

=(5*(count(A1:A7)+3)-sum(A1:A7))/3

explaination:

The first Problem is, that you need a specific sum
to get an specific average:

count of all values x 5 = searched sum (10*5=50)
you have 7 values: 7 x 5 = 35
You search 3 values: 3 x 5 = 15
sum to reach : (7x5)+(3x5)=15+35=50

assuming the sum of your existing 7 values are 32....
50-32=18,
dividing the Rest (18) by 3 (your cells)
18 / 3 = 6 .


Greets
Chris