Get instant live expert help on I need help with excel formula average

“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

getting #NAME error in excel AVERAGE formula
Solved by F. F. in 30 mins
How do I create an average formula so that every time I update the month on excel the average ultimately changes without having to manually calculate the average?
Solved by A. C. in 18 mins
I need help with excel formula on summing based on critrea and then calculating the average
Solved by Z. D. in 18 mins
On the Grade Average worksheet, select G7 and type "Average." In cell G8, use a formula to generate the average of the contents in Cells B8:F8. Use the fill handle to populate your results through G10. The syntax for the Excel Average function is the following: AVERAGE(argument1, [argument2],...). Arguments can be numbers, named ranges, cell references that contain numbers, or arrays. Select Cell A12, and enter "Class Average." Use a formula to generate the average of IP Assignment 1 in cell B12. Use the fill across handle to populate your results of averaging the other assignments to F12
Solved by Z. A. in 22 mins
So i'm taking the average of a range of 30 cells from another sheet. For example, My formula in Sheet 2 is =average(Sheet1!B5:B35) and when I drag that formula down one cell I get =average(Sheet1!B6:B36) but I want it to do =average(Sheet1!B36:B65).
Solved by A. A. in 17 mins