Excel DCOUNT Function Tutorial

Ayyukan DCOUNT yana ɗaya daga cikin ayyukan ayyuka na Excel. An tsara wannan rukunin ayyuka don yin sauƙi don taƙaita bayanin daga manyan manyan bayanai na bayanai. Suna yin haka ta hanyar dawo da bayanan da suka dace akan daya ko fiye da ma'auni da mai amfani ya zaɓi. Za a iya amfani da aikin DCOUNT don ƙididdiga dabi'u a cikin wani ɓangaren bayanan da ya dace da ka'idodi.

01 na 08

DCOUNT Yarjejeniya da jayayya

A don aikin DCOUNT shine:

= DCOUNT (database, filin, ma'auni)

Dukkan ayyuka na ƙididdiga suna da nau'i uku guda uku:

• Database : (da ake buƙata) Yana ƙayyade kewayon tantanin salula wanda ke dauke da bayanan. Dole ne a hada sunayen sunaye a cikin kewayon.
• Field : (da ake bukata) Ya nuna wane shafi ko filin ya kamata a yi amfani da shi a cikin lissafinsa. Shigar da hujja ko ta hanyar buga sunan filin a quotes - kamar "Radius" - ko shigar da lambar mahallin - kamar 3.
• Criteria : (da ake buƙata) Lissafin kewayon kwayoyin da ke dauke da yanayin da mai amfani ya ƙayyade. Tsarin ya kamata ya haɗa da akalla sunan filin daya daga cikin bayanai kuma a kalla sauran tantancewar salula wanda ya nuna yanayin da za a kimantawa ta hanyar aikin.

02 na 08

Misali Yin Amfani da Hanyoyin Aiki na Excel ta DCOUNT - Daidaita Mahimmanci na Ƙarshe

Danna kan hoton da ke sama don duba mafi girma akan wannan misali.

Wannan misali zai yi amfani da DCOUNT don samun yawan adadin daliban da suka shiga cikin shekara ta farko na shirin kolejin su.

03 na 08

Shigar da Bayanan Tutorial

Lura: Koyarwar ba ta haɗa matakan tsarawa ba. Bayani game da zaɓuɓɓukan tsara aikin aiki suna samuwa a cikin wannan Tutorial Shirya Talla .

1. Shigar da teburin bayanai kamar yadda aka gani a cikin hoton da ke cikin sel D1 zuwa F15
2. Bar cell F5 blank - wannan shi ne inda aka samar da takaddun DCOUNT
3. Za a yi amfani da sunayen filin a cikin kwayoyin D2 zuwa F2 a matsayin ɓangare na aikin ƙwararriyar Criteria

04 na 08

Zabi Takaddun

Don samun DCOUNT don bincika bayanai kawai don daliban shekaru na farko muna shigar da lamba 1 a ƙarƙashin sunan filin shekara a jere 3.

1. A cikin salula, F3 rubuta ma'auni 1
2. A cikin tantanin halitta E5 kamar rubutun Ƙari: don nuna bayanin da za mu samu tare da DCOUNT

05 na 08

Namar da Database

Yin amfani da madaidaicin labaran don manyan jeri na bayanai irin su database ba zai iya sauƙaƙe kawai ya shigar da wannan hujjar a cikin aikin ba, amma kuma zai iya hana kurakurai ta hanyar zaɓin ɓangaren ba daidai ba.

Jirgin da ake kira suna da amfani sosai idan ka yi amfani da irin wannan jinsin yawancin sau da yawa a cikin lissafin ko a lokacin da aka tsara sigogi ko sigogi.

1. Sanya sassa D6 zuwa F15 a cikin takardun aiki don zaɓar iyakar
2. Danna sunan akwatin sama a sama da shafi na A a cikin takardun aiki
3. Rubuta Rubutun shiga cikin akwatin akwatin don ƙirƙirar mai suna
4. Latsa maɓallin shigarwa akan keyboard don kammala shigarwa

06 na 08

Ana buɗe akwatin maganganun DCOUNT

Maganar maganganun aiki yana samar da hanya mai sauƙi don shigar da bayanai ga kowane muhawarar aikin.

Ana buɗe akwatin maganganu don ƙungiyar bayanai na ayyuka da aka yi ta danna kan maɓallin wizard na aiki (fx) dake kusa da maɓallin tsari a sama da takardun aiki - duba hoto a sama.

1. Danna kan salula F5 - wurin da za a nuna sakamakon aikin
2. Danna maɓallin wizard ɗin aiki (fx) icon don kawo akwatin zane mai Sanya Sauti
3. Rubuta DCOUNT a cikin Bincike don aikin aiki a saman akwatin maganganu
4. Danna maɓallin GO don bincika aikin
5. Dole ne akwatin maganganu ya sami DCOUNT kuma ya lissafa shi a cikin Zaɓi aikin aikin
6. Danna Ya yi don buɗe akwatin maganganun DCOUNT

07 na 08

Ƙarshen Magana

1. Danna kan Database Database na akwatin maganganu
2. Rubuta adireshin mai suna Shiga cikin layi
3. Danna kan filin filin akwatin maganganu
4. Rubuta sunan filin "Shekara" a cikin layi - tabbas ya hada da alamomi
5. Danna maɓallin Lissafi na akwatin maganganu
6. Sanya sassa D2 zuwa F3 a cikin takardar aiki don shigar da kewayon
7. Danna Ya yi don rufe akwatin maganganun DCOUNT kuma kammala aikin
8. Amsar 3 ya kamata ya bayyana a cell F5 tun bayanan sau uku - waɗanda ke cikin layuka 7, 10, da 13 - nuna ɗaliban da aka rubuta a cikin shekarar farko na shirin su.
9. Lokacin da ka danna kan salula F5 da cikakken aikin
   = DCOUNT (Rubuta, "Shekara", D2: F3) ya bayyana a cikin maɓallin tsari a sama da takardun aiki

Lura: Idan muna so mu sami yawan adadin daliban da aka sa hannu, zamu iya amfani da aiki na yau da kullum na COUNT, tun da ba mu buƙatar saka ma'auni don ƙididdige abin da aikin ke amfani da shi ba.

08 na 08

Kuskuren Matsala na Database

#Value : Yana faruwa mafi sau da yawa idan ba a hada sunayen filin a cikin bayanan bayanai ba.

Ga misali a sama, tabbatar da cewa sunaye sunaye a cikin sel D6: F6 an haɗa su a cikin Labaran da aka haifa .