Скачать или смотреть What is Average,AveragA,Averageif Function in Excel

AVERAGE function
This article describes the formula syntax and usage of the AVERAGE function in Microsoft Excel.
Description
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], ...)
The AVERAGE function syntax has the following arguments:
◾ Number1 Required. The first number, cell reference, or range for which you want the average.
◾ Number2, ... Optional. Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.
AVERAGEA function
This article describes the formula syntax and usage of the AVERAGEA function in Microsoft Excel.
Description
Calculates the average (arithmetic mean) of the values in the list of arguments.
Syntax
AVERAGEA(value1, [value2], ...)
The AVERAGEA function syntax has the following arguments:
◾ Value1, value2, ... Value1 is required, subsequent values are optional. 1 to 255 cells, ranges of cells, or values for which you want the average.
AVerageif Function
This article describes the formula syntax and usage of the AVERAGEIF function in Microsoft Excel.
Description
Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
Syntax
AVERAGEIF(range, criteria, [average_range])
The AVERAGEIF function syntax has the following arguments:
Range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria Required. The criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged. For example, criteria can be expressed as 32, "32", "32", "apples", or B4
Average_range Optional. The actual set of cells to average. If omitted, range is used.
.
.
.
.
.
.
.
#exceltutorialinhindi
#exceltutorialforbeginners
#excel#microsoftexcelexcel
#excelinhindihindi
#excelinhinditutorial
#excelhinditutorial
#microsoftexcel
#excelbyeducatepoint
#exceltutorials
#Completemicrosoftexceltutorial
#excel2019 #excel2020
#excelinhindifullcourse
#excelforbeginners2020
#excelfullcoursehindi
#educatepoint
#learnexcelinhindi
#exceltips2020
#exceltutorialforbeginnersinhindi
Connect with Educate Point on social media for the latest Video, promos, and much more:
► Subscribe: https://www.youtube.com/channel/UCqfI...
► Facebook: https://www.facebook.com/profile.php?...
► Instagram:   / educate_point  
-----------------------------------| Thanks |------------------------
#microsoftexcel #excel #excelshortcutsinhindi