 # Get instant live expert help on I need help with formula for average in excel “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 automatically average for every 5 rows in excel and have the average row appear in a new sheet?
Solved by M. F. in 23 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
I need to calculate average number of male and female directors for each company in the Excel sheet.
Solved by D. Y. in 30 mins