Shaqada DGET ee Excel waa shaqo Database ka soo saarta kaydka kaydka hal diiwaan oo u dhigma shuruudaha la cayimay. Habka shaqada DGET waa DGET (database, field, standards). Ujeedada shaqada DGET waa in laga helo qiimaha diiwaanka iswaafajinta, sidaas darteed haddii aysan jirin wax qiyam ah oo ku habboon shuruudaha, DGET waxay soo celin doontaa qiimaha qaladka # VALUE , iyo haddii wax ka badan hal qiime ay u dhigmaan shuruudaha, qiimaha qaladku waa # NUM .

Syntax ee shaqada DGET waa:

• Database : Kala duwanaanshaha xogta unugyada. Waa loo baahan yahay.
• Goobta^(Field) : Muuji tiirka loo isticmaalo shaqada. Waa loo baahan yahay.
• Shuruudaha^(Criteria) : Kala duwanaanta unugyada ay ku jiraan shuruudaha la cayimay. Waa loo baahan yahay.

Akhri^(Read) : Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel^{(How to use the HLOOKUP function in Microsoft Excel)} .

Sida loo isticmaalo shaqada DGET gudaha Excel

Fur Microsoft Excel .

Miis samee ama fur miis jira.

Casharradan, waxaan rabnaa inaan ka helno wadarta rinjiga farshaxanka cas ee madow ee kaydka xogta.

Sidoo kale, samee shaxda shuruudaha.

Geli qolka; waxaad rabtaa inaad natiijada dhigto; geli =DGET(A1:D5, “Total,” A9:D10) .

A1:D5 waa database-ka.

Wadarta guud^(Total) waa garoonka

A9:D10 waa shuruudaha.

Natiijadu waa kow iyo labaatan^{(Twenty One)} .

Akhri^(Read) : Sida loo qoro, loo dhiso, oo loo isticmaalo shaqada VLOOKUP ee Excel^{(How to write, build, and use VLOOKUP function in Excel)} .

Waxaa jira hab kale oo loo isticmaalo shaqada DGET .

Habka kale waa inaad gujiso badhanka fx ee korka warqadda shaqada.

Sanduuqa wada hadalka Doorka Function^{(Select Function)} ayaa soo bixi doona.

Qaybta Dooro Qaybta^{(Select a Category)} , dhagsii falaarta hoos u dhacda oo ka dooro Database liiska.

Qaybta Dooro Function^{(Select a Function)} , ka dooro DGET liiska.

Kadib, OK .

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

1. Qaybta Database- ka, geli A1:D5 sanduuqa gelitaanka
2. Qaybta Goobta^{(Field )} , Geli Wadarta^(Total) sanduuqa gelitaanka.
3. Qaybta Shuruudaha^{(Criteria )} , geli A9:D10 sanduuqa gelitaanka.

Markaa OK .

Waxaan rajeyneynaa in casharkan uu kaa caawinayo inaad fahamto sida loo isticmaalo shaqada DGET ee Microsoft Excel.

Hadda akhri^{(Now read)} : Sida loo isticmaalo shaqada REPT ee Microsoft Excel^{(How to use the REPT function in Microsoft Excel)} .

How to use the DGET function in Excel

The DGET function in Excel is a Database function that extracts from a database a single record that matches the specified criteria. The formula for the DGET function is DGET (database, field, criteria). The purpose of the DGET function is to get value from a matching record, so if no values match the criteria, DGET will return error value #VALUE, and if more than one value matches the criteria, the error value #NUM.

The Syntax for the DGET function is:

• Database: The database range of cells. It is required.
• Field: Indicate the column used in the function. It is required.
• Criteria: The range of cells that contain the specified conditions. It is required.

Read: How to use the HLOOKUP function in Microsoft Excel.

How to use the DGET function in Excel

Open Microsoft Excel.

Create a table or open an existing table.

In this tutorial, we want to get the total for dark red art paint from the database.

Also, create a criteria table.

Enter In the cell; you want to place the result; enter =DGET(A1:D5, “Total,” A9:D10).

A1:D5 is the database.

Total is the field.

A9:D10 is the criteria.

The result is Twenty One.

Read: How to write, build, and use VLOOKUP function in Excel.

There is another method to use the DGET function.

The other method is to click the fx button on top of the worksheet.

A Select Function dialog box will pop up.

In the Select a Category section, click the drop-down arrow and select Database from the list.

In the Select a Function section, select DGET from the list.

Then, OK.

A Function Arguments dialog box will pop up.

1. In the Database section, enter A1:D5 into the entry box.
2. In the Field section, enter Total into the entry box.
3. In the Criteria section, enter A9:D10 into the entry box.

Then OK.

We hope this tutorial helps you understand how to use the DGET function in Microsoft  Excel.

Now read: How to use the REPT function in Microsoft 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 isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?

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

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

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

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

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

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

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

• Sida loo isticmaalo shaqada Mode ee Excel