Finding Average Min and Average Max

[OminousDark]

Hello, I am using Excel 2010 and I am currently trying to find the Avg Min / Avg Max costs for 4 different groups.. Players, Accompanying, Coaches, Medical.

I need it to get the minimum values from 3 different sections ( I am using custom names for them such as PlayerReg for Player Registration costs ) once it gathers the minimum / maximum values from the 3 different sections it needs to add them together to display the Avg Minimum / Maximum for each group.

At the moment I have =MIN(Total_Discount_7_Nights + PlayerReg + FrequentFlierFare) under Minimum /w Frequent Flier although the minimum value it should detect is $948.75 it displays $1115.

For maximum I have =MAX(Total_Discount_7_Nights + PlayerReg + FrequentFlierFare) under Maximum /w Frequent Flier although once again this value should be $1174.50 Although for some reason it displays $978.75 - which is the minimum cost. The Maximum figures for the other groups (Accompanying, Coaches and Medical) don't even display values Instead it just has #VALUE! in which I'm guessing I have something wrong with it.

As you can see I am not the best at all with this stuff, Any help is appreciated This seems to be one section I am completely stuck on


Regards
OminousDark

 

[Andrew Poulsom]

Welcome to MrExcel.

Did you confirm your formulas with Ctrl+Shift+Enter, not just Enter?

 

[OminousDark]

No, I did not. Thanks a lot, something so simple. How could I have forgotten :/ - Like I said thanks a ton