View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neo1
 
Posts: n/a
Default Goal Seel To get Average!?


Hello just a problem I have which I cant seem to get right...

I have the following numbers:

5
6
9
24
56
=Sum of all those numbers above

=Average of the 5 numbers above

Can I actually use goal seek so that I can change my average to another
number by changing say the sum total?

Thanks for your time
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=517079