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

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