Excel Tip: Averaging Grades with AVERAGEIF( )

This one comes from a friend who wants to know how to average out a score for each person from a list where scores are recorded multiple times for each person.

Subscribe for more Excel tips and get your free ebook on getting “Hired with Excel.” 

In this video I demonstrate how to do this in Excel using the AVERAGEIF function. I also demonstrate how absolute references and the ROUND function can add to the utility of this worksheet.

Teachers — anything else? Your questions answered, free. 

Given it’s back-to-school time, I’ve been asked a few Excel questions from teachers. This would make a wonderful course. So if you’ve got questions about using Excel — for grading, scheduling,

So if you’ve got questions about using Excel — for grading, scheduling, however you use it — email me! email hidden; JavaScript is required. I will answer your questions free, and they may end up on the course. 

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: