“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Solved by F. C. in 18 mins

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.

Solved by F. F. in 19 mins

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.

Solved by A. D. in 13 mins

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!

Solved by Z. D. in 22 mins

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!

Solved by K. C. in 21 mins

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

Solved by B. W. in 30 mins

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

Solved by X. W. in 29 mins

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.

Solved by M. E. in 23 mins

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.

Solved by B. J. in 21 mins

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

Solved by D. Q. in 13 mins