AVERAGEIF Function | AVERAGEIF() | Microsoft Excel

Let’s learn how to use the AVERAGEIF() function in Microsoft Excel. The AVERAGEIF() function in microsoft excel will return the mean of any numerical data set that fit some criteria that we describe. So, when we call our function we are asked for a range, a criteria and optional an average range. Our range is all the numbers that we wish to check against our criteria. You can think of the criteria as a filter, only the values that fit our criteria will be averaged, and lastly the average range is optional and only applied if we want to average a value that is not our range, otherwise range will be used.

Follow & Support StudySession: Channel Memberships: https://www.youtube.com/channel/UCaFHlSOg83nCUIHlFMlUhPw/join Email Us: StudySessionBusiness@gmail.com Twitter: https://twitter.com/StudySessionYT Instagram: https://instagram.com/StudySessionyt/

This video is part of our Microsoft Excel course. Microsoft Excel is a program used in many different branches of work and learning this software is extremely beneficial to many peoples employability. In this Learn Microsoft Excel playlist you'll learn everything from the fundamentals to much more complicated topics. #studysession #shorts #microsoftexcel ... https://www.youtube.com/watch?v=sdiBArXhHRA