AVERAGEIF iyo AVERAGEIFS waa labadaba hawlo xisaabeed^{(Statistical)} n Microsoft Excel . Maqaalkan, waxaan ku eegi doonaa eray-bixintooda iyo sida loo isticmaalo.

Shaqada AVERAGEIF waxay qiimaysaa celceliska dhammaan tirooyinka kala duwan ee buuxiya shuruudaha la bixiyay. Habka AVERAGEIF waa:

 Averageif (Range, criteria, [average_range])

Shaqada AVERAGEIFS waxay soo celisaa celceliska dhammaan tirooyinka kala duwan oo buuxiya shuruudo badan. Habka AVERAGEIFS waa:

 Averageifs (average_range, criteria_range1, criteria1[criteria_ range2, criteria2] …)

Erayga AVERAGEIF iyo AVERAGEIFS

Celceliska^(AVERAGEIF)

• Range : waa kooxda unugyada aad rabto inaad celcelis ahaan sameyso. Range ayaa loo baahan yahay.
• Shuruudaha^(Criteria) : Shuruudaha^(Criteria) waxaa loo isticmaalaa in lagu xaqiijiyo unugyadee celcelis ahaan noqonayaan. Shuruudaha^(Criteria) ayaa loo baahan yahay.
• Celceliska_kala duwanaanshaha^{(Average_range)} : Kala duwanaanshaha^(Range) unugyada ilaa celceliska. Marka la waayo, cabbirka cabbirku wuxuu noqonayaa dhexdhexaad. Celceliska_kala-duwanaanshaha^{(Average_range)} waa ikhtiyaari.

Celceliska^(AVERAGEIFS)

• ^{(Average_range)}Celceliska_range : Celcelis ahaan_ Range^{(Average_ Range)} waa hal ama ka badan oo unug ilaa celcelis ahaan. Celcelis ahaan_kala duwan^{(Average_range)} ayaa loo baahan yahay.
• Range : kooxda unugyada aad rabto in aad celcelis ahaan. Range ayaa loo baahan yahay.
• Shuruudaha_range1^{(Criteria_range1)} : Range -ka ugu horreeya ee lagu qiimeeyo shuruudaha la xiriira. Shuruudaha_kala^{(Criteria_range1)} duwanaanshaha 1aad ayaa loo baahan yahay, laakiin cabbirka labaad_ waa ikhtiyaari.
• Shuruudaha 1^{(Criteria 1)} : Shuruudaha^(Criteria) ayaa xaqiijiya unugyada celceliska. Shuruudaha ugu horreeya ayaa loo baahan yahay. Shuruudaha labaad ama shuruud kasta ka dib waa ikhtiyaari.

Sida loo isticmaalo AVERAGEIF gudaha Excel

Marka hore, waxaan dooneynaa inaan gujino unugga meesha aan rabno Celceliska^(Average) . Kadibna ku qor =Averageif bracket.

Gudaha bracket-ka, waxaanu ku qori doonaa Range -ka sababtoo ah Range of cells ayaa ka kooban xogta aan rabno in aan isku celcelino.

Casharradan, waxaan ku qori doonaa unugga ( D3:D9), ama waxaan ku dhufan karnaa unugga tiirka ku yaal ee aan rabno inaan isku celcelino oo u jiidno dhammaadka; Tani waxay si toos ah u gelin doontaa kala duwanaanta unugyada caanaha caanaha.

Haddaba, waxaynu gelaynaa Shuruudaha^(Criteria) ; shuruudaha ayaa ansixiya unugyada celceliska. Waxaan u adeegsan doonaa casharradan rootiga^(Bread) sababtoo ah waa waxa aan raadineyno.

Waxaan geli doonaa celceliska kala duwanaanshaha^{(Average_ range)} . Waxaan ku qori doonaa G3: G9 sababtoo ah unugyadani waxay ka kooban yihiin iibka aan rabno inaan isku celcelino; ka dibna xidh xidhidhiyaha.

Riix Gelida^(Enter) , waxaad arki doontaa natiijada.

Doorashada kale waa inaad aado Formulas . Kooxda Maktabada Function^{(Function Library)} , dooro Shaqooyin Badan^{(More Functions)} . Liiska liiska hoos-u-hoosaadka ah, ka dooro Statistical menu ka dooro AVERAGEIF. Sanduuqa wada hadalka doodda Function^{(Function Argument)} ayaa soo muuqan doona.

Sanduuqa wada hadalka doodaha Function^{(Function Arguments)} , meesha aad ku aragto Range , ku qor D3:D9 sanduuqa soo gelida.

Sanduuqa wada hadalka doodaha Function^{(Function Arguments)} , halka aad ku aragto Shuruudaha^(Criteria) , ku qor "Rooti"^{(“Bread”)} sanduuqa gelida shuruudaha.

Sanduuqa wada hadalka doodaha Function^{(Function Arguments)} , halka aad ku aragto Average_range , ku qor G3:G9 sanduuqa soo gelida.

Guji OK oo waxaad arki doontaa natiijadaada.

Akhri: ^(Read:) Sida loo isticmaalo SUMIF iyo SUMIFS Functions gudaha Excel^{(How to use SUMIF and SUMIFS Functions in Excel)}

Sida loo isticmaalo AVERAGEIFS gudaha Excel

Casharradan, waxaanu ku eegaynaa celceliska iibka badeecadaha uu iibsaday macmiilku 110.

Guji^(Click) unugga meesha aad natiijada ka rabto, dabadeed ku qor =Averageif , bracket.

Nooca garabka G3:G9 , kani waa celceliska_kala duwanaanshaha^{(Average_range)} .

Hadda waxaan dooneynaa inaan ku qorno Shuruudaha_range1^{(Criteria_range1)} . Nooca D3:D9 , unugyadan kala duwan ayaa ka kooban xogta aan raadineyno.

Waxaan ku qori doonaa shuruudaha 1^(Criteria1) , taas oo ah "Rooti"^{(” Bread”)} sababtoo ah waa badeecada aan raadineyno.

Waxaan ku ganaaxeynaa Criteria_range2^{(Criteria_range2)} , taas oo ah A3: A9 sababtoo ah waxaan rabnaa inaan aqoonsanno macmiilka.

Waxaan gali doonaa Criteria2 , oo ah "110," sababtoo ah kani waa lambarka aqoonsiga macmiilka aan raadineyno.

Riix Geli oo^{(Enter and )} waxaad arki doontaa natiijadaada.

Doorashada kale waa inaad aado Formulas . Kooxda Maktabada Function^{(Function Library)} , dooro Shaqooyin Badan^{(More Functions)} . Liiska liiska hoos-u-hoosaadka ah, ka dooro Tirakoobka^{(Statistical)} menu-kiisa dooro AVERAGEIFS ; iyo sanduuqa wada hadalka doodda Function ayaa soo bixi doona.^{(Function Argument)}

In sanduuqa wada hadalka doodaha Function^{(Function Arguments)} , halkaas oo aad ku aragto Celceliska_range^{(Average_range)} . Ku qor G3:G9 sanduuqa soo gelida.

In sanduuqa wada hadalka doodaha Function^{(Function Arguments)} , halkaas oo aad ku aragto Criteria_range1 . Ku qor D3:D9 sanduuqa soo gelida.

Sanduuqa gelitaanka Criteria1 , ku qor ^(Criteria1)rootiga^(Bread) .

Gudaha Criteria_range2 sanduuqa gelida, ku qor A3:A9 .

Sanduuqa gelitaanka Criteria2 , ku qor ^(Criteria2)"110" sababtoo ah waxaan raadineynaa id 110 macmiilka.

Guji OK _ Waxaad arki doontaa natiijada.

Akhri soo socda^{(Read next)} :  Sida loo isticmaalo IF Function ee Excel.^{(How to use the IF Function in Excel.)}

How to use AVERAGEIF and AVERAGEIFS in Excel

AVERAGEIF and AVERAGEIFS are both Statistical functions n Microsoft Excel. In this post, we will take a look at theіr syntax and how to use them.

The AVERAGEIF function evaluates the average of all numbers in a range that meet a given criterion. The formula for the AVERAGEIF is:

 Averageif (Range, criteria, [average_range])

The AVERAGEIFS function returns the average of all numbers in a range that meets multiple criteria. The formula for AVERAGEIFS is:

 Averageifs (average_range, criteria_range1, criteria1[criteria_ range2, criteria2] …)

Syntax of AVERAGEIF and AVERAGEIFS

AVERAGEIF

• Range: is the group of cells you want to average. The Range is required.
• Criteria: The Criteria is used to verify which cells to average. Criteria are required.
• Average_range: The Range of cells to average. When absent, the range parameter will be average instead. Average_range is optional.

AVERAGEIFS

• Average_range: The Average_ Range is one or more cells to average. Average_range is required.
• Range: the group of cells you want to average. The Range is required.
• Criteria_range1: The first Range to evaluate the related criteria. The first Criteria_range1 is required, but the second criteria_ range is optional.
• Criteria 1: The Criteria verify which cells to average. The first criteria are required. The second criteria or any criteria after is optional.

How to use AVERAGEIF in Excel

First, we are going to click the cell where we want the Average. Then type =Averageif bracket.

Inside the bracket, we will type the Range because the Range of cells contains the data we want to average.

In this tutorial, we will type the cell (D3:D9), or we can click on the cell in the column that we want to average and drag it to the end; this will automatically place the range of cells in the formula.

Now, we are going to enter the Criteria; the criteria validate which cells to average. We are going to use Bread in this tutorial because it is what we are looking for.

We are going to enter the Average_ range. We will type G3:G9 because these cells contain the sales we want to average; then close the bracket.

Press Enter, you will see the result.

The other option is to go to Formulas. In the Function Library group, select More Functions. In the drop-down menu list, select Statistical in its menu choose AVERAGEIF. A Function Argument dialog box will appear.

In the Function Arguments dialog box, where you see Range, type D3:D9 into its entry box.

In the Function Arguments dialog box, where you see Criteria, type “Bread” into the criteria entry box.

In the Function Arguments dialog box, where you see Average_range, type G3:G9 into its entry box.

Click OK and you will see your result.

Read: How to use SUMIF and SUMIFS Functions in Excel

How to use AVERAGEIFS in Excel

In this tutorial, we are going to look up the average sale of products bought by customer 110.

Click the cell where you want the result in, then type =Averageif, bracket.

In the bracket type G3:G9, this is the Average_range.

Now we are going to type the Criteria_range1. Type D3:D9, this range of cells contain the data we are looking for.

We will type the Criteria1, which is” Bread” because it is the product we are looking for.

We are going to fine Criteria_range2, which is A3:A9 because we want to identify the customer.

We will enter Criteria2, which is“110,” because this is the ID number of the customer we are looking for.

Press Enter and you will see your result.

The other option is to go to Formulas. In the Function Library group, select More Functions. In the drop-down menu list, select Statistical in its menu select AVERAGEIFS; and a Function Argument dialog box will appear.

In the Function Arguments dialog box, where you see Average_range. Type G3:G9 in its entry box.

In the Function Arguments dialog box, where you see Criteria_range1. Type D3:D9 in its entry box.

In the Criteria1 entry box, type Bread.

In the Criteria_range2 entry box, type A3:A9.

In the Criteria2 entry box, type “110” because we are looking for the customer id 110.

Click OK. You will see the result.

Read next: How to use the IF Function in Excel.

Related posts

• Sida loo isticmaalo COUNTIFS, SUMIFS, AVERAGEIFS gudaha Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel