Average , AverageIF , AverageIFS in Excel | Statistical Function | हिंदी मे
Автор: The Office Crew
Загружено: 2021-10-27
Просмотров: 26714
In this video we will learn how to use statistical function (Average) in excel using example and explanation
1. Average function in excel
2. AverageIF function in excel
3. AverageIFS function in excel
1. Average : Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
Syntax : AVERAGE(number1, [number2], ...)
2. Average IF : Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
Syntax : =AVERAGEIF(range, criteria, average_range)
3. AverageIFS : Returns the average (arithmetic mean) of all cells that meet multiple criteria.
Syntax : =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Best regards,
The Office Crew
By Sachin Tanwar
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
