Get instant live Excel expert help with AVERAGE Function

how to average a column in excel? I need to find the average of column K sorted by column E and H

I need some help on a weighted average application in Excel. This is a follow-up to what was done earlier today. I need to get the correct formula for R4.

I need help on a conditional weighted average. I was helped earlier today, but the solution is not quite what I need. The formula in R4 is not adjusting for when cell P4 and Q4 are blank.

Using this formula: =" Net PSU "&AVERAGE(Q3:Q14) I want the result of the Q3 through Q14 average to display to whole numbers, no decimals... can't figure it out!

I need help with this formula: =" Net PSU "&AVERAGE(Q3:Q14) I would like it to display the result of the average as a whole number with no decimal points. Help!

I need to calculate average position in excel. How do I do this?

I am calculating averages and want to restrict any cells with a value of zero from the calculation of the average

I have an excel workbook with 13 sheets in it. These sheets are populated with data on companies (see worksheet example posted). I want to create a master sheet at the end that extracts data from the rest of the workbook based on it meeting certain criteria. In each of the 13 sheets, there are anywhere between 1-30 rows of companies, with 21 pieces of data about them in the columns. 9 of these columns have rankings in them on a scale of 1-4, which are then averaged in the last column. If this average is above 2, I want the 9 ranking columns, as well as the column identifying the company to be extracted into the master sheet at the end. I am posting an example of what I mean on the sheet.

You can see there is time stamps from 11:00 to 18:00. The excel hasy 4 key values, which is in colum D(Elsi Name). Now our tool generates this report hourly and sometimes some venue has 6 Elsi names, some have 10 elsi names. You can see that these 4 Elsi names are highlighted on each timestap from, group of 4 for 1100, group of 4 for 1200 etc. I want to see the average of all the values of these 4 Elsi names aggregated against every timestap and make pivot charts from that aggregated data of each 4 Else names. I want it to be i n a way so when in future when i create these charts populate automatically wether the timestamps are from 900 to 1500 or 1100 to 1800 and regardless of how many Elsi names there are.

how do I get the rolling average of 3 data points where the data increases by 1 new data point every week. also, there may be certain weeks where no new data is added but I need the average of the last 3 data points