Shaqada DCOUNT waxay tirisaa unugyada ka kooban tirooyinka goobta ama tiirka diiwaanka ee kaydka Haddii ikhtiyaarka goobta uu maqan yahay, DCOUNT waxay tirin doontaa dhammaan diiwaannada ku jira kaydka ee u dhigma shuruudaha. Qaabka shaqada DCOUNT waa = DCOUNT (database, field, criteria).

DCOUNTA waxay tirisaa unugyo aan madhan^(DCOUNTA) oo ku jira kaydka xogta. Doodda goobta shaqada ee DCOUNTA waa ikhtiyaari; haddii ikhtiyaarka goobta uu maqan yahay, DCOUNTA waxay tirin doontaa dhammaan diiwaannada ku jira keydka macluumaadka ee u dhigma shuruudaha. Qaabka shaqada DCOUNTA waa = DCOUNTA (database, field, criteria).

Isku dhafka DCOUNT iyo Shaqada ^{(DCOUNTA Function)}DCOUNTA^(DCOUNT)

DCOUNT

• Database : Kala duwanaanta unugyada ka kooban kaydinta xogta. Database ayaa loo baahan yahay.
• Goobta^(Field) : waxay tuseysaa tiirka loo isticmaalo shaqada. Beerta ayaa loo baahan yahay.
• Shuruudaha^(Criteria) : Kala duwanaanta unugyada ay ku jiraan xogta aad tilmaantay. Shuruudaha ayaa loo baahan yahay.

DCOUNTA

• Database : Kala duwanaanta unugyada ka kooban kaydinta xogta. Database ayaa loo baahan yahay.
• Goobta^(Field) : waxay tuseysaa tiirka loo isticmaalo shaqada. Goobtu waa ikhtiyaari.
• Shuruudaha^(Criteria) : Kala duwanaanta unugyada ay ku jiraan xogta aad tilmaantay. Shuruudaha ayaa loo baahan yahay.

Sida loo isticmaalo DCOUNT Function gudaha Excel

Qaybtan casharrada, waxaan rabnaa inaan helno tirada dadka da'doodu ka yar tahay labaatan jir.

Marka hore, dhagsii unugga meesha aad rabto inaad xogtaada dhigto, unuggana ku qor shaqada =DCOUNT , ka dib bracket.

Gudaha gunta, waxaanu ku dari doonaa Database- ka . Xog-ururinta ayaa noqon doonta shaxda oo dhan, kaas oo ah A1:C9 .

Waxaan ku dari doonaa Field , taas oo ah da'da^(Age) sababtoo ah da'du waa waxa aan raadineyno. Nooca "Age" isticmaal oraah labanlaab ah sababtoo ah waxaad isticmaalaysaa kelmad ku jirta qaacidada.

Hadda, waxaan ku dari doonaa Shuruudaha^(Criteria) . Waxaan isticmaali doonaa miis yar oo ka kooban da'da^(Age) , in ka yar labaatan ( fiiri sawirka kore^{(see in the photo above)} ) sababtoo ah waxaan tirin doonaa tirada dadka ka yar labaatan; nooca E5: E6 , ka dibna xidh xidhidhka.

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

DCOUNT waxay tirisaa oo kaliya unugyada ka kooban tirooyinka.

Haddii aad isku daydo inaad isticmaasho shaqada DCOUNT adoo isticmaalaya tiirar ay ku jiraan xarfo laakiin aan lambar ahayn, natiijadu waxay noqon doontaa eber^(Zero) .

Sida loogu isticmaalo shaqada DCOUNTA^{(DCOUNTA Function)} gudaha Excel

Qaybtan, waxaan u isticmaali doonaa shaqada DCOUNTA si aan u tirino inta qof ee shaxda LastName waa Johnson .

Guji^(Click) unugga meesha aad rabto inaad ku dhejiso xogtaada nooca unugga =DCOUNTA , kadibna bracket.

Gudaha gunta, waxaanu ku dari doonaa Database- ka . Xog-ururinta ayaa noqon doonta shaxda oo dhan, kaas oo ah A1:C9 .

Waxaan ku dari doonaa Garoonka^(Field) . Isticmaalka tiirka LastName , ee shaxda sida garoonka, hubi in "LastName" waa in xigasho double.

Waxaan u soconaa Shuruudaha^(Criteria) , taas oo ah xogta ku jirta miiska yar ( fiiri sawirka^{(see photo)} ). Nooca E5:E6 . Xir xidhid

Riix Gelida^(Enter) . Waxaad arki doontaa natiijada.

DCOUNTA waxay tirisaa unugyo ka kooban tirooyinka iyo xarfaha labadaba.

Waa kaas!

Hadda akhri: ^{(Now read:)} Sida loo isticmaalo AVERAGEIF iyo AVERAGEIFS gudaha Excel^{(How to use AVERAGEIF and AVERAGEIFS in Excel)} .

How to use DCOUNT and DCOUNTA Function in Excel

The DCOUNT function counts the cells that contain numbers in a field or column of records in a database. If the field option is absent, DCOUNT will count all records in the database that matches the criteria. The formula for the DCOUNT function is = DCOUNT (database, field, criteria).

The DCOUNTA counts nonblank cells in a database. The DCOUNTA function field argument is optional; if the field option is absent, DCOUNTA will count all records in the database that matches the criteria. The formula for the DCOUNTA function is = DCOUNTA (database, field, criteria).

Syntax of DCOUNT and DCOUNTA Function

DCOUNT

• Database: The range of cells that make up the database. A database is required.
• Field: implies which column is used in the function. The field is required.
• Criteria: The range of cells that contain the data you indicate. Criteria are required.

DCOUNTA

• Database: The range of cells that make up the database. A database is required.
• Field: implies which column is used in the function. The field is optional.
• Criteria: The range of cells that contain the data you indicate. Criteria are required.

How to use DCOUNT Function in Excel

In this part of the tutorial, we want to find the number of persons whose age is under twenty.

First, click the cell where you want to place your data, in the cell type the function =DCOUNT, then bracket.

Inside the bracket, we are going to add the Database. The database will be the entire table, which is A1:C9.

We will add the Field, which is Age because age is what we are looking for. Type “Age” use double quotation because you are using a word in the formula.

Now, we are going to add the Criteria. We will use the mini table containing Age, less than twenty (see in the photo above) because we will count the number of persons under twenty; type E5:E6, then close the bracket.

Press Enter, you will see your result.

DCOUNT only count cells that contain numbers.

If you try to use the DCOUNT function using columns that contain letters but not a number, the result will be a Zero.

How to use DCOUNTA Function in Excel

In this section, we will use the DCOUNTA function to count how many persons in the table LastName is Johnson.

Click the cell where you want to place your data in the cell type =DCOUNTA, then bracket.

Inside the bracket, we are going to add the Database. The database will be the entire table, which is A1:C9.

We will add the Field. Using the column LastName, in the table as the field, ensure that “LastName” is in a double quotation.

We are going to Criteria, which is the data in the mini table (see photo). Type E5:E6. Close bracket.

Press Enter. You will see the Result.

DCOUNTA counts cells that contain both numbers and letters.

That’s it!

Now read: How to use AVERAGEIF and AVERAGEIFS in Excel.

Related posts

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo RANDBETWEEN Function gudaha Excel

• Sida loo isticmaalo shaqada TYPE ee Excel

• Sida loo isticmaalo Excel Hyperlink Function

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo tiriyo lambarka Haa ama Maya 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

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

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

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

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo isticmaalo Saacadda, Daqiiqada, iyo Shaqada Labaad ee Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel