Ujeedada shaqada SUMIF waa in lagu soo koobo qiyamka kala duwan ee buuxiya shuruudaha aad sheegtay ama lagu daro tiro ku salaysan hal shuruud. SUMIF waxay qaadataa saddex dood oo kala ah Range , Shuruudaha^(Criteria) , iyo Isku -^(Sum-range) dhafka . Dooduhu waa qiyam ay shaqadu isticmaasho si ay u qabato hawlo ama xisaabin ku jirta qaacido.

Shaqada SUMIFS waxay ku daraysaa dhammaan doodaheeda oo buuxiya shuruudo badan. Amarka shaqada SUMIFS way ka duwan tahay shaqada SUMIF . Gudaha SUMIF , wadarta guud_^{(Sum_ range)} waa doodda saddexaad. Gudaha SUMIFS , Sum_range waa doodda koowaad.

Farqiga u dhexeeya SUMIF iyo SUMIFS Syntax

SUMIF Syntax

• Range : Kala duwanaanta unugyada aad rabto in shaqadu xisaabiso. Unugyada kala duwani waa inay ahaadaan tirooyin, magacyo, arraysyo, iyo tixraacyo ka kooban tirooyin.
• Shuruudaha^(Criteria) : Xaaladda ama shuruudaha ay tahay inaad ka fiiriso inta lagu jiro doodda koowaad. Nidaamku waa qaab qoraal, nambar, iyo odhaah tilmaamaysa, unugyadee lagu dari doonaa.
• Sum_range : Kala duwanaanshaha wadarta ama unugyada lagu darayo. Sum_range waa^{(Sum­_range)} ikhtiyaari.

Qaaciddada ayaa ah SUMIF (range, criteria, [sum_range]).

Syntax SUMIFS^{(SUMIFS Syntax)}

• Sum_range : kala duwanaanshaha unugyada in lagu daro.
• Criteria_range^{(Criteria_range 1)} 1
• Shuruudaha 1^{(Criteria 1)} : Wuxuu go'aamiyaa tirada unugyada lagu daro.
• Criteria_range2, standard2^{(Criteria_range2, criteria2)} : Kala duwanaanta dheeraadka ah iyo shuruudaha la xidhiidha. Dooddani waa ikhtiyaari. Qaaciddada ayaa ah SUMIFS (sum_range, criteria_range1, criteria1 [criteria_range2, criteria2,..].

Sida loo isticmaalo shaqada SUMIF ee Excel

Shaxdan, waxaan rabnaa inaan xisaabino tirada canbaha la iibiyo.

Waxaan dooneynaa in aan riixno unugga meesha aan rabno in aan dhigno natiijada.

Kadibna ku qor unugga=SUMIF (

Waxaan raadineynaa  Range . Maqaalkan,  Range  waa meesha aad ku aragto miraha sababtoo ah waxaan rabnaa inaan helno tirada canbaha la iibiyo.

Qaado cursorka oo dhagsii unugga B3 ee ku jira tiirka midhaha, ka dibna taabo  Ctrl ,  Shift , iyo  furaha fallaadha hoose^{(Down Arrow Key)} si aad u iftiimiso xogta B10 ee tiirka ama ku qor B3:B10 . Waxaad ku arki doontaa Range of cells in formula. Markaa ku dar koma

Dabadeed ku dar Shuruudaha^(Criteria) , oo ah Cambaha^(Mango) , sababtoo ah waxaan rabnaa inaan helno wadarta canbaha oo la iibiyay, ka dibna ku dar comma.

Ku dar Sum_range , xogta ku taal tiirka ku calaamadsan Tirada Iibka^{(Number of Sales)} , ee soo bandhigaysa alaabta uu iibsaday macmiil kasta.

Guji^(Click) unugga xogta ugu horreysa ee tirada tiirarka iibka . ^{(Number of Sale )}Riix Ctrl, Shift , iyo Furaha fallaadha Down^{(Down Arrow Key)} si aad u muujiso xogta tiirka. Kadibna ku dar gunta ama ku qor C3:C10 .

Riix^(Press) geli Waxaad arki doontaa natiijada.

Doorashada kale waa in la aado tab Formulas ee shaqada iyo kooxda maktabadda; dhagsii Xisaab and Trig^{(Math and Trig)} .

Liiska hoos-u-dhaca ah, dooro SUMIF . Sanduuqa wada hadalka doodda shaqada ayaa soo muuqan doona.

Sanduuqa Gelitaanka Range , ku qor B3:B10.

Sanduuqa gelitaanka shuruudaha , ku qor ^(Criteria)canbaha^(Mango) sababtoo ah waxaan rabnaa inaan helno inta canbaha ee la iibsaday.

Gudaha Sum_range sanduuqa gelida nooca C5:C10, tiirkani waa meesha tirada alaabta la iibsaday ama ku taal.

Riix OK _ Waxaad arki doontaa natiijada.

Sida loo isticmaalo shaqada SUMIFS gudaha Excel

Casharradan, waxaan rabnaa inaan ku darno tirada guud ee iibka cambe ee aan ka sameynay, dheh, Kevin Sahadeo .

Guji^(Click) unugga meesha aad rabto in natiijadu noqoto. Nooca^(Type) , =SUMIFS ()unugga dhexdiisa.

Shaqada SUMIFS , waxaanu ku dari doonaa Sum_range marka hore, taas oo ah xogta ku jirta tirada tiirarka iibka^{(Number of Sales)} , taas oo cadaynaysa inta shay ee uu iibsaday macmiil kasta.

Ku qor unugga C3:C10 ama guji C3 oo taabo Ctrl , Shift , iyo Down Arrow Key si aad hoos ugu muujiso C10 , ka dibna ku dar comma.

Ku dar inta u dhaxaysa shuruudaha 1^{(Criteria range 1)} . Guji xogta ugu horeysa ee tiirka midhaha oo geli unugyada B3:B10 ama Ctrl , Shift iyo Down furaha^{(Down arrow key)} si aad u muujiso unugyada.

Ku qor canbaha sida Shuruudaha^(Criteria) .

Hadda waxaan ku dari doonaa Rajada Labaad ee Shuruudaha^{(Second Criteria Range)} . Tag tiirka macmiilka^(Customer) oo guji xogta ugu horeysa ee shaxda iyo Ctrl , Shift , iyo Down Arrow Key si aad u muujiso ama u qor A3:A10 , comma.

Waxaan ku dari doonaa Shuruudaha Labaad^{(Second Criteria)} oo ah Kevin Sahadeo . Hubi inaad ku qorto higaada saxda ah ee qaaciidada oo isticmaal magaca oo buuxa. Riix Gelida^(Enter) waxaad arki doontaa natiijada.

Xulashada kale waa inaad gujiso Formulas tab ee kooxda maktabadda shaqada, dooro Xisaab iyo Trig^{(Math and Trig)} ee liiska hoos-u-dhaca, dooro SUMIFS . Sanduuqa wada hadalka doodda shaqada ayaa soo muuqan doona.

Sanduuqa soo gelista Sum_range , ku qor C3:C10sababtoo ah tani waa tirada iibka ee aan dooneyno inaan ku darno.

Nooca sanduuqa soo gelida ee Criteria_ kala duwan^{(Criteria_ range)}B3:B10 sababtoo ah kani waa kala duwanaanshaha halka midhaha, aanu raadinayno.

Sanduuqa shuruudaha^(Criteria) gelitaanka, ku qor Mangosababtoo ah waxaan rabnaa inaan helno inta cambe ee Kevin Sahadeo^{(Kevin Sahadeo)} iibsaday.

In the Criteria_ Range 2 nooca sanduuqa gelitaanka A3:A10, sababtoo ah kani waa kala duwanaanshaha labaad ee aad kor u raadinayso, halkaas oo magaca Kevin Sahadeo waa.

Sanduuqa shuruudaha 2^{(Criteria 2)} , ku qor Kevin Sahadeosababtoo ah waxaan rabnaa inaan ogaano inta cambe ee uu qofkani iibsado.

Kadib dhagsii OK. Waxaad arki doontaa natiijada.

Waxaan rajeynayaa inaad u aragto qoraalka mid faa'iido leh.

Akhri soo socda^{(Read next)} : Sida loo abuuro Shaxda Pivot iyo Shaxda Pivot ee Excel^{(How to create a Pivot Table and Pivot Chart in Excel)} .

How to use SUMIF and SUMIFS Functions in Excel

Τhe SUMIF function purpose is to sum the values in a range that meets the criteria you specify or add a range based on a single criterion. SUMIF takes three arguments Range, Criteria, and Sum-range. Arguments are values that a function uses to perform operations or calculations in a formula.

The SUMIFS function adds all its arguments that meet multiple criteria. The orders of the SUMIFS function is different from the SUMIF function. In SUMIF, the Sum_ range is the third argument. In SUMIFS, the Sum_range is the first argument.

Difference between SUMIF and SUMIFS Syntax

SUMIF Syntax

• Range: The range of cells you want the function to calculate. The cells in range must be numbers, names, arrays, and references that contain numbers.
• Criteria: The condition or criteria you must look up for in the range provided in the first argument. The criteria are in the form of a text, number, and expression that identifies, which cells will be added.
• Sum_range: The range to be sum or cells to be added. The Sum­_range is optional.

The formula is SUMIF (range, criteria, [sum_range]).

SUMIFS Syntax

• Sum_range: the range of cells to add.
• Criteria_range 1: The range of cells that is analyzed using criteria 1.
• Criteria 1: Determines the range of cells to add.
• Criteria_range2, criteria2: The additional ranges and their associated criteria. This argument is optional. The formula is SUMIFS (sum_range, criteria_range1, criteria1 [criteria_range2, criteria2,..].

How to use the Excel SUMIF function

In this table, we want to calculate the number of mangoes sold.

We are going to click the cell where we want to place the result.

Then type in the cell =SUMIF (

We are going to look for the Range. In this article, the Range is where you see the fruits because we want to find the number of mangoes sold.

Take the cursor and click on the cell B3 in the fruit column, then press the Ctrl, Shift, and the Down Arrow Key to highlight the data to B10 in the column or type B3:B10. You will see the Range of cells in the formula. Then add a comma.

Then add the Criteria, which is Mango, because we want to find the sum of mangoes sold, then add a comma.

Add the Sum_range, the data located in the column labeled Number of Sales, that Displays the items purchased by each customer.

Click the cell of the first data in the Number of Sale columns. Press the Ctrl, Shift, and the Down Arrow Key to highlight the column’s data. Then add a bracket or type C3:C10.

Press enter. You will see the result.

The other option is to go to the Formulas tab in the function and library group; click Math and Trig.

In the drop-down menu, select SUMIF. A function argument dialog box will appear.

In the Range entry box, type the B3:B10.

In the Criteria entry box, type Mango because we want to find how many mangoes were Purchased.

In Sum_range entry box type C5:C10, this column is where the number of items purchased or located.

Press OK. You will see the result.

How to use the SUMIFS function in Excel

In this tutorial, we want to add the total number of sales of mangoes we made from, say, Kevin Sahadeo.

Click the cell where you want the result to be. Type, =SUMIFS () in the cell.

In the SUMIFS function, we will add the Sum_range first, which is the data in the Number of Sales columns, which specify how many items were purchased by each customer.

Type the cell C3:C10 or click on C3 and press the Ctrl, Shift, and Down Arrow Key to highlight down to C10, then add a comma.

Add the Criteria range 1. Click the first data in the fruits column and enter the cells B3:B10 or Ctrl, Shift and Down arrow key to highlight the cells.

Type Mango as Criteria.

Now I am going to add the Second Criteria Range. Go to the Customer column and click on the first data in the table and Ctrl, Shift, and Down Arrow Key to highlight or type A3:A10, the comma.

We are going to add the Second Criteria, which is Kevin Sahadeo. Ensure you type it the exact spelling in the formula and use the full name. Press Enter you will see the result.

The other option is to click on the Formulas tab in the function library group, select Math and Trig in the drop-down menu, select SUMIFS.  A function argument dialog box will appear.

In the Sum_range entry box, type C3:C10 because this is the number of sales we want to add up.

In the Criteria_ range entry box type B3:B10 because this is the range where the fruit, we are looking for is.

In the Criteria entry box, type Mango because we want to find how many mangoes Kevin Sahadeo purchased.

In the Criteria_ Range 2 entry box type A3:A10, because this is the second range you are looking up, where the name Kevin Sahadeo is.

In the Criteria 2 entry box, type Kevin Sahadeo because we want to find out how many mangoes this person purchases.

Then click OK. You will see the result.

I hope you find the post useful.

Read next: How to create a Pivot Table and Pivot Chart in Excel.

Related posts

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo isticmaalo MIN, Max, iyo AVERAGE Functions gudaha Excel

• Sida loo isticmaalo Beddelka iyo Bedelka Hawlaha gudaha Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo shaqada DISC gudaha Excel

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

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel