Get instant live Excel expert help to learn how to create a statistical function in Excel?

I want to have a formula that calculates the average of the two highest %back for each athlete using specific races. I have not been able to find a way to select more than 3 races as it will not work. For example: =(SUM(LARGE(J3,L3,P3,1),LARGE(J3,L3,P3,2)))/2 The second set of data points (J3,L3,P3) will not be selected a second time.

i need a pivot table that shows the avg gpa, act, sat score for each year. For example, 2013, what was the average GPA, ACT, SAT scores for that group of individuals.

I need a formula that will divide blanks by a set number and then calculate an average using a weighted system and give an overall average for four inputs. I want to be able to ignore one, two, or three of the numbers whenever it is zero. Here is a sample formula from one of the cells: =(((((E11/$E$8)*100) *0.2)+(((F11/$F$8)*100)*0.15)+(((G11/$G$8)*100)*0.15)+(((H11/$H$8)*100)*0.2))/70)*100 How would I add an "ignore if zero" function in the above formula?

I need an average function for excel for the subtotals

In pivot table I want to add; Column G (To Be named "AVE_COSTS_TOTAL") SUM of column B, column c, column D, MAX result of column E Column H (To be named "AVE_MARGIN") MAX of column F - Column G Column I (To be named "AVE_MARGIN_%) % difference of column F and column G (e.g = (Column H - Column G)/Column G*100%) I have attempted to create calculated fields to produce the above, however the figures produced are inaccurate due to MAX columns. I found that Excel performed sums with MAX columns as if they were SUMS columns. I've had some technical support who advised that in order to create these columns within the pivot table, I would need "Power Pivot". For an unknown reason I was unable to download this program and I also have a very short time frame to produce this document !!!!! Please see "RAW DATA AVERAGES" tab for the pivot which I would like data added. The data in this pivot leverages from the "RAW DATA" tab. You can also see that the pivot totals are incorrect. E.G Column B, Row 4. The column figure should be an average of all costs in that section. The total should be $898.96?

a ranking of average sales with the highest value being ranked #2

how do i get the answer to a lookup problem with excel i have to find the average grade test score in the grading criteria

I have a row of contiguous numbers (set b) and I want to obtain a distribution of the whole integer values at their median location of that row in a new row and I want the average value of the same subset used to arrive at the integer in set B, but from set A in a different column.

I want to find the ticket average by zip code. how to pivot in excel?

In the current cell, use the average function to calculate the average quarterly revenue for the fiscal year ( do not use the insert function wizard