Excel Conditional Average Formula - AVERAGEIF Function

Write a conditional average formula in Excel to return the average exam score for different subjects.
The AVERAGEIF function can be used in Excel to create a conditional average. This is a really useful function for summarising values such as exam scores.
This video tutorial takes you through writing an AVERAGEIF function including using absolute cell references when copying a formula.
Find more great free tutorials at;
www.computerga...
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

[@meganraya538]

This was very helpful. I really enjoyed your tips and tricks for the different short cuts as well. Thank you. :)

[@Computergaga]

Very happy to help Megan.

[@syedasad2747]

Amazing video! I was browsing all over RUclips for someone to explain in in a simple way. Thanks for the help

[@Computergaga]

My pleasure!

[@stan4288]

This was extremely helpful..I had scowered through tonnes of videos just to find a solution to a set of data I was working on that required this...thank u so much

[@Computergaga]

You're welcome!

[@sandymohsenhabib6471]

Thank You

[@yandanimbobosi2575]

Thank you for your help. Im doing an assignment (last minute) you've been really helpful

[@Computergaga]

Glad I could help Yandani.

[@mw9368]

Love your accent and learned a lot, thank you!!!!

[@Computergaga]

Thank you! 😃

[@saml5073]

Hi there. I've really enjoyed all of your videos that I've watched so far but I was wondering if you could please help me with a function I'm trying to perform. In short, I have a set of scores, recorded at different distances (set integer values) however these scores are sometimes graded out of three possible totals. Can you please advise/refer me to the best excel formula for my situation. Many thanks! Keep the videos coming.

[@Computergaga]

Thank you Sam. If I understand your question correctly I think a VLOOKUP being used for the range lookup would work. I have a video here - ruclips.net/video/ddBIEhryTwM/видео.html
This demonstrates it to provide discounts based on amount ordered, but this can easily be adapted to work with scores and totals instead.

[@realfootballhighlights3220]

Great Work, Learnt a lot. Fantastic Job!! please keep up the good :)

[@Computergaga]

Thank you very much 😊

[@wesleyharper3253]

Really helpful, thank you

[@Computergaga]

You're very welcome. Thanks, Wesley.

[@hilarysuniverse8303]

Hello thank you so much for this amazing video, but i’m just a little confused of why on the IT formula it’s F5 instead of F4 ? Please help me out please thank you!

[@Computergaga]

F5 is the adjacent cell to the formula containing the word "IT". Column F contains the subjects with are averaging scores for. Each subject is to the left of the formula.

[@johnnymax5580]

thank you, bro, very helpful

[@Computergaga]

You're welcome. Thank you, Johnny.

[@edwardmerritt358]

This is great! What if I want 2 conditions? For instance, if there was another column for grade level, and I wanted to know the Average score for French Grade 8 students and the average for French grade 9 (and so on for each language and grade level.

[@Computergaga]

Thank you, Edward. Sure, you can use the AVERAGEIFS function to handle multiple conditions in the same way.

[@abhayk3877]

Sir will you please explain the "Average sum for a specific date range in excel" if you made any video on it please give me a link.