Get instant live Excel expert help with AVERAGE Function

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a table of data showing how much each individual produced every day of the year. I then summed the total for each individual for the entire year. I would like to narrow down which individuals had a total below average, shown on a different table. I am only able to countif individuals were below average, but I want to show specifically which ones were below average, instead of going manually and picking which ones were below and which ones weren't (it is a lot of data). I have already used conditional formatting to help me visualize which ones were above average (shown in green cells) and which ones were below average (red), but I would still have to pick them individually if I were to represent in a new table specifically which ones were below average. Any help on which equation can perform this action? It would be something like show which individuals were below average, and the result would be about 50 data points in 50 different cells.
Solved by S. H. in 25 mins
A 555-mile, 5-hour plane trip was flown at two speeds. For the first part of the trip, the average speed was 105 mph. Then the tailwind picked up, and the remainder of the trip was flown at an average speed of 115 mph. For how long did the plane fly at each speed?
Solved by F. F. in 26 mins
Hello, I'm trying to graph an average value against non average values. I am struggling because I have only one x value for my average data point and multiple x values for the other data points.
Solved by O. U. in 23 mins
I am trying to find the weighted average excel with a group of date.
Solved by I. J. in 16 mins
Play with different values for the Average Annual Return and see how a small change in the rate can have a big effect on your return. Over 30 years, the average inflation-adjusted returns for the S&P 500 have been between 5–8%. Use a lower percentage to be more conservative in your calculations. This would move you toward over-saving rather than over-estimating and being caught short at retirement.
Solved by F. L. in 13 mins
I would like to create a 60 day rolling average every time I enter data in a new column. I would like to have the average and standard deviation calculator to calculate every time data is entered in a new column.
Solved by A. F. in 26 mins
I would like to create a scatter chart using 2 data series where i'm able to place the average in the center of the chart.
Solved by B. J. in 18 mins
I'm trying to calculate an average in a table, but I don't know how to automatically select which cells to average based on the certain criteria...
Solved by I. J. in 17 mins
Question 6: Create a multitab UserForm which has 2 tabs. Under a tab named Statistics and using the data found on the Stats.xlsx worksheet, allow the user to select the data, and then display in a MsgBox these statistics: The average of the selected data The standard deviation of the selected data The largest value in the selected data The smallest value in the selected data The median of the selected data Also need run button.
Solved by E. U. in 26 mins
I would like to create a formula to calculate conditional average: column 1 I have years and corresponding to each year, in column 3 I have number of days to payment. I would like to calculate the average of the number of days corresponding to each year and automatically start a new average calculation when the year changes. Note that the years in column 1 are not in order, they go from 2017 till 2015 for each customer. Is there a way to achieve this?
Solved by I. Q. in 27 mins