Excel DCOUNT Function Tutorial

Iko DCOUNT basa rimwe remabasa eDeccel's database . Iri boka remabasa rakagadzirirwa kuita kuti zvive nyore kupfupisa mashoko kubva pamatafura makuru e data. Vanoita izvi kuburikidza nekudzorera ruzivo rwakajeka kubva pane imwe kana kupfuura zvingasarudzwa nemushandisi. Iko DCOUNT basa rinogona kushandiswa kukwana zviyero mumutsetse we data unosangana nemitemo yakatemwa.

01 ye 08

DCOUNT Syntax uye Arguments

Iyo ye DCDC basa iri:

= DCOUNT (dhiabhorosi, munda, maitiro)

Zvose zvinoshandiswa pakutsvakurudza mabhuku zvakagadzikana zvakafanana zvitatu:

• Dhiyabhorosi : (inodikanwa) Inotsanangura huwandu hwemaferensi esero rine database. Mazita emunda anofanira kunge akabatanidzwa mukati.
• Munda : (inodikanwa) Inoratidza kuti ndeypi imwe nhare kana munda inofanira kushandiswa nebasa iri kuverenga. Pinda nharo kana kuisa zita remunda mune zvinyorwa - zvakadai se "Radius" - kana kupinda mu column inhamba-yakadai se3.
• Mhosva : (inodiwa) Inotarisa rutivi rwemasero ane zvimiso zvakataurwa nemushandisi. Urwu hunofanira kunge runosanganisira imwe zita remunda kubva kune dhesi uye imwechete imwe sero rinotarisa chirwere chinofanira kuongororwa nebasa racho.

02 of 08

Muenzaniso Kushandisa DC Excel Function - Kufananidza Criterion Chena

Dzvanya pamufananidzo uri kumusoro pamusoro pekuona kukuru kwemuenzaniso uyu.

Uyu muenzaniso uchashandisa DCOUNT kuti uwane nhamba yose yevadzidzi vakanyoresa mugore rokutanga rekorogi yavo.

03 of 08

Kupinda Tutorial Data

Cherechedza: Dzidzo haina kuisa maitiro ekufambisa. Mashoko pamusoro pekufambisa mafirimu ekushandurwa kwemashizha anowanikwa mune iyi Basic Excel Kuburitsa Tutori .

1. Pinda tafura ye data sezvinoonekwa mumufananidzo uri pamusoro apa mumasero D1 kusvika F15
2. Siya sero F5 rakashama - iyi ndiyo iyo mufananidzo we DCOUNT uchange uripo
3. Munda unoshandiswa mumasero D2 kusvika kuF2 uchashandiswa sechikamu chebasa reCriteria argument

04 of 08

Kusarudza Mazano

Kuti tiwane DCOUNT kutarisa chete data yevadzidzi vekutanga vekutanga tinopinda nhamba 1 pasi pezita remunda wegore mugore ra3.

1. Muchitokisi, F3 nyora inyanzvi 1
2. Muchikamu cheE5 chengetedza musoro weChitatu : kuratidza ruzivo ruchazowana ne DCOUNT

05 of 08

Kunyorera Database

Kushandisa mazita akanzi mazita makuru e data akadai se database haagoni kungoita kuti zvive nyore kupinda mharo iyi mubasa, asi inogonawo kudzivirira kukanganisa kunokonzerwa nokusarudza nzvimbo isina kururama.

Zita rakatumidzwa inobatsira kana iwe ukashandisa masero emamwe masero kakawanda mukuverenga kana pakuumba marati kana mairafu.

1. Simbisai masero D6 kusvika F15 mubasa rekushanda kuti musarudze maruva
2. Dzvanya pabhokisi bhokisi pamusoro apa korome A mune pepa rekushanda
3. Tora Kuiswa muzita rebhokisi kuti uite zita rakarongwa
4. Dhinda pikicha inopinda mubhobhoyo kuti upedze kupinda

06 of 08

Kuvhura dhora reDVD Dialog

Basa rebhokisi rebhokisi rinopa nzira iri nyore yekupinda dhidhiro yega yega yebasa remashoko.

Kuzarura bhokisi rebhokisi reboka re database rekuita kunoitwa nekutsvaga purogiramu yebasa wizard (fx) inowanikwa pedyo nebharuti yepamusoro pane pepa pepaji - ona mufananidzo uri pamusoro.

1. Dzvanya pane cell F5 - nzvimbo iyo migumisiro yebasa icharatidzwa
2. Dzvanyira pane bhidhiyo yemhizha wizard (fx) kuti uuye neInter Function dialog box
3. Tora DCOUNT mu Tsvaga yewindo rebasa pamusoro pebhokisi rebhokisi
4. Dzvanya ku GO kuenda kunotsvaka basa
5. Iyo bhokisi rebhokisi rinofanira kuwana DCOUNT uye ronyora iyo muSarudzo yebasa
6. Dzvanya OK kuti uzarure DCOUNT basa dialog box

07 of 08

Kuzadzisa Arguments

1. Dzvanya paDhesi yeNhamba yebhokisi rebhokisi
2. Tora zita rezita raunyoresa kupinda mumutsara
3. Dzvanya paMunda webhokisi rebhokisi
4. Nyora munda wezita rokuti "Year" mumuganhu - iva nechokwadi chokuti unosanganisira quotation marks
5. Dzvanya paCriteria line yebhokisi rebhokisi
6. Dzorerai masero D2 kusvika kuF3 mubasa rekushanda kuti uende pakuronga
7. Dzvanya OK kuti uvhare DCOUNT basa dialog box uye upedze basa
8. Mhinduro 3 inofanira kuonekwa muchikamu cheF5 sezvo zvinyorwa zvitatu chete - izvo zviri mumitsara 7, 10, uye 13 - zvinoratidza mudzidzi seanonyora mugore rokutanga rerongwa hwavo
9. Paunenge uchinyora pane cell F5 basa rakakwana
   = DCOUNT (Kunyoresa, "Gore", D2: F3) inowanikwa mubhairi yepamusoro pane pepa pepaji

Cherechedza: Kana tichida kuwana chiwandu chevadzidzi vakanyoresa, tinogona kushandisa maitiro COUNT nguva dzose, sezvo hatifaniri kutaurira zvigadziro kuderedza kuti chii chinoshandiswa nebasa racho.

08 we 08

Dhiyabhorosi Basa Rinosvibisa

#Value : Inowanzoitika kakawanda apo mazita emumunda akanga asina kubatanidzwa munyaya ye database.

Nokuda kwemuenzaniso uri pamusoro apa, iva nechokwadi chokuti munda unoshevedza mumasero D6: F6 akabatanidzwa mune zvakanyorwa zita rakanyorwa.