How to Use AVERAGEIF and AVERAGEIFS Function in Excel
By using #AVERAGE function, we can get the average of any numbers, but when we want AVERAGE based on our conditions, then we use #AVERAGEIF or #AVERAGEIFS function.
Using the AVERAGEIF function, averaging can be done on the basis of only one condition, but when there is more than one condition, the AVERAGIFS function which was introduced in the version of Excel 2007 has to be used.
In this video, I have explained in full detail about AVERAGEIF and AVERAGIFS, as well as an alternative way to do average without AVERAGIFS function, in which SUMIFS and COUNTIFS function are used. Watch this video till the end and know about these two functions.
All About Average-Basic👇
• Statistical Function : AVERAGE, AVERAGEA, ...
-------------------------------------------------------------------------------------------------------------
Subscribe to YouTube & Follow on Facebook Page👇
/ exceluniverse
www.facebook.com/exceluniverse.pkp
How to use Nested IF in Excel👇
• Nested IF in Excel
All About Average-Basic👇
• Statistical Function : AVERAGE, AVERAGEA, ...
Extract Unique List in Excel 2016👇
• How to Extract Unique List Using Formula i...
How COUNTIFS Function Work👇
• How to use COUNTIFS Function in Excel-Live...
COUNTIF and COUNTIFS Function👇
• Excel COUNTIF and COUNTIFS Function | Exce...
SUMIFS Basic Concept👇
• How to use the Excel SUMIFS Function | SUM...
SUMIF Function👇
/ -0nsa3smmt
Download Practice File👇
https://mega.nz/file/Z7J10AgT#H3xSyBG...