Shaqada DSUM ee Excel waxay soo koobaysaa tiir shax ku salaysan iyadoo lagu saleynayo shuruudo badan oo aad sheegtay. Shaqada DSUM waa shaqo Database . Qaabka shaqada DSUM^{(DSUM Function)} waa (database, field, standard)

Isku dhafka Shaqada DSUM

• Database : Unugyada ka kooban Database-ka
• Fields : wuxuu muujinayaa tiirka loo isticmaalo shaqada
• Shuruudaha^(Criteria) : Shuruudaha ayaa kala duwan oo aad sheegtay

Sida loo isticmaalo shaqada DSUM gudaha Excel

Fur Microsoft Excel.

Fur miiska jira ama samee miis cusub.

Tababarkan, waxaan rabnaa inaan helno iibinta Barbie Extra Dolls laga bilaabo sagaalaad ilaa lix iyo tobnaad ee Janaayo^(January) .

Miiska hoose, waxaad abuurtay. Samee miis yar oo shuruudaha aad raadinayso. Casharradan, waxaan ku abuureynaa miis yar oo leh beeraha, toy, iyo iibka.

Goobta " Toy ", waxaan ku dhejin doonaa shuruudaha aan raadineyno, taas oo ah " Barbie Extra Doll ."

Waxaan dhigi doonaa cursorka unugga hoostiisa Goobta^(Field) “ Iibka^(Sales) ” oo ku qor unugga =DSUM , ka dibna garabka.

Gudaha gunta, ku qor Database- ka , kaas oo ah miiska ( A2: E8 ).

• Meel hakad ah oo ku qor Goobta^(Field) , kaas oo ah magaca goobta unugga ( E2 ).
• Dabadeed hakad kale dhig oo ku qor Shuruudaha^(Criteria) . Shuruudaha waa waxa aad raadineyso ( A11 : ^(Criteria)A12^(A11:A12) ).

Habkani waa inuu u ekaado sidan =DSUM (A2:E8, E2, A11:A12) .

Riix Gelida^(Enter) waxaad arki doontaa natiijooyinka.

Doorashada kale waa in aad gujiso Gelida Shaqada^{(Insert Function)} ( fx )

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

In sanduuqa wada hadalka, dooro qaybta Database .

Dooro shaqada DSUM , dabadeed taabo OK .

Sanduuqa wada hadalka doodaha shaqada^{(Function Arguments)} ayaa soo bixi doona.

Sanduuqa wada hadalka doodaha Functions^{(Functions Argument)} , ku qor sanduuqa gelinta Database A2:E8 .

Sanduuqa Gelitaanka Goobta^(Field’s) , ku qor E2 ama " Iibka^(Sales) ."

Sanduuqa gelitaanka shuruudaha^(Criteria) , ku qor A11:A12 oo tabo OK .

Waxaan rajeynayaa in tani ay tahay mid waxtar leh; haddii aad hayso su'aal, fadlan faallo ka bixi hoos.

Akhri soo socda^{(Read next)} : Sida loo Isticmaalo EDATE iyo Function EOMONTH gudaha Excel^{(How to Use EDATE and EOMONTH Function in Excel)} .

How to use DSUM function in Excel

The DSUM Function in Excel sums up a column in a table based on multiple criteria that you specify. The DSUM function is a Database function. The formula for the DSUM Function is (database, field, criteria)

The syntax for the DSUM Function

• Database: The cells that make up the Database
• Fields: reveals which column is to be used in the function
• Criteria: The criteria range you specify

How to use DSUM function in Excel

Open Microsoft Excel.

Open an existing table or create a new table.

In this tutorial, we want to find Barbie Extra Dolls sales from the ninth to sixteenth of January.

Below the table, you have created. Create a mini table of the criteria you are going to look for. In this tutorial, we create a mini table with the fields, toy, and sales.

In the Field “Toy,” we will put the criteria we are going to look for, that is “Barbie Extra Doll.”

We will place the cell’s cursor under the Field “Sales” and type in the cell =DSUM, then bracket.

Inside the bracket, type the Database, which is the table (A2:E8).

• Place a comma and type the Field, which is the cell’s field name (E2).
• Then place another comma and type the Criteria. The Criteria is what you are looking for (A11:A12).

The formula should look like this =DSUM (A2:E8, E2, A11:A12).

Press Enter you will see the results.

The other option is to click Insert Function (fx)

An Insert Function dialog box will appear.

In the dialog box, select the category Database.

Select the function DSUM, then press OK.

A Function Arguments Dialog box will pop up.

In the Functions Argument dialog box, type in the Database entry box A2:E8.

In the Field’s entry box, type E2 or “Sales.”

In the Criteria entry box, type A11:A12 and press OK.

I hope this is helpful; if you have a question, please comment below.

Read next: How to Use EDATE and EOMONTH Function in Excel.

Related posts

• 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 isticmaalo sifada Nooca Xogta tooska ah ee Excel

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

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?

• Sida loogu isticmaalo DEC2Bin gudaha Excel si loogu beddelo nambarka jajab tobanle ee binary

• Sida loo midoobo oo loo kala saaro unugyada Excel

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

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo qoro, loo dhiso, loona isticmaalo shaqada VLOOKUP gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

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

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel