Get instant live Excel expert help with AVERAGE Function

I am trying to get the graph under 'Monthly Graph' to show the percentage as an average for each line inserted

Hi, what is average function in excel? i'm having trouble getting my average function to work for the whole column in a table, it does the sum instead or won't drag down

Trying to get a sum or an average from an array if two criteria are met.

Hi I would like help with an average that links different boxes together, i tired to follow a formula recommended to me but didnt get it to work thank s

I am attempting to calculate the average of a column using the 'AVERAGEIF' the cells in the range are greater than 0. I have accomplished this part. In the same cells I also want to use an IF statement that leaves the cell blank if this average (the value of the cell) is equal to zero.

I have a range of 10 numbers on a row. I use a formula to obtain the average of the 5 highest numbers in the range of 10 numbers. However, I add a new number to the range each week and drop the oldest number or number 10. Is there a way to add the new number to the left side of the range and drop the oldest number on the right side of the range without having to delete number 10 then cut and paste to slide the 9 numbers to the right to make room for the new number on the left?. I.e, drop the last number on the right slide of the 10 number range, have remaining 9 numbers shift to the right one cell and add the new number in cell number 1.

I have a pivot table that shows each individual persons average broken down by hour. In column A is the hour (8 for 8:00 AM) and in column J is their average for that hour. On a second sheet (same workbook) I have the total average for each hour for the entire team.

How can I take the average (in the yellow Highlighted cells) of just the just the names/ids chosen? chose and not the entire range of values in the cells that may be hidden or unselected? and the totals (the blue highlighted cells) for the just the names/ids chosen?

i need a fake set of data, don't ask me why. 5 random number with the set average must be same with my current data.

Context: Reading and Spelling age score sheet (eg. a student takes a test and it tells them what their 'reading age' is- 14.03 would be 14 years and 3 months). Problem: Need to calculate progress for each student + average progress for each year group. Issues: Have tried converting ages to months using this formula (=12*LEFT(C11,FIND(".",C11)-1)+MID(C11,FIND(".",C11)+1,9)) but ran into various issues (treating .10 as .01 for some reason and producing #VALUE error for scores ending in .00 (presumably because MID function won't work if value below 1) Action: Have gone back to raw data set (attached). Can you help?