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!”
Here are some problems that our users have asked and received explanations on
how to find the average value of a function to calculate the time period to create and shorten table to just each hour
Solved by G. E. in 19 mins
I need to figure out how to get an excel function to continue showing a sum or average without certain cells filled, until those cells are filled.
Solved by V. W. in 17 mins
How can I found an hourly average for sound levels
Solved by T. W. in 29 mins
A coworker tried to update the account names in my pivot table. Somehow she added a 2 to the end of all these Microsoft accounts. It causes my 4 week average formula to stop working, since it references the account name. These are all the #NA's you see in the right column. How can I edit the name back to the original so the formulas work again? I just need to remove the 2's from the end of each name. Thanks
Solved by M. Y. in 14 mins
I am trying to calculate the average finish for each team in our fantasy football league. However the first 2 years we had 8 teams and the last 4 years we have had 10 teams. How would I calculate the average to account for 8th place being last place versus 10th place being last place?
Solved by I. J. in 21 mins
Hi everybody, I'm breaking my head to put together an excel formula, for my college work.
The table needs to validate 2 information. According to the number of employees and the sector, whether it is Industry or Commerce / services.
Industry:
Micro: with up to 19 employees
Small: 20 to 99 employees
Average: 100 to 499 employees
Large: more than 500 employees
Trade and Services
Micro: up to 9 employees
Small: from 10 to 49 employees
Average: 50 to 99 employees
Large: more than 100 employees
That is, in a cell I will have a number of employees, and with this information, I need to be verified if it is an industry or trade information that will also be in another cell. By then yes it can classify it as Micro, small, medium and large.
Solved by V. Y. in 14 mins
1. create a bar chart that clearly shows the average revenue per economy car versus the quarter for 2015.
Solved by D. F. in 29 mins
how to take average in excel for an array of values?
Solved by A. A. in 21 mins
when using =sumifs(table[x] etc etc etc) the data set for x does not highlight, and as result I am unable to create the rolling average i require
Solved by B. J. in 28 mins
NEED TO STOP VALUE COMING UP IN TIME DIFFERENCE
NEED TO BE A DAILY LOADING SHEET HOW TO STORE DATE BUT CHANGE DATE TOO
NEED PIVOT TO CATCH AND STORE DATA ON ANY LOAD GOING OUT AS AN AVERAGE OVERTIME.
THANKS
Solved by F. Y. in 23 mins