Excel DCOUNT Maphunziro a Ntchito

Dongosolo la DCOUNT ndi limodzi la ntchito ya database ya Excel. Gulu la ntchitoyi lakonzedwa kuti likhale losavuta kufotokozera mwachidule nkhani kuchokera ku matebulo aakulu a deta. Amachita izi mwa kubwezeretsanso mfundo zenizeni zochokera pa chimodzi kapena zingapo zomwe zasankhidwa ndi wogwiritsa ntchito. Dongosolo la DCOUNT lingagwiritsidwe ntchito kuti liwononge chiyero chonse mu chigawo cha deta chomwe chikutsatira ndondomekoyi.

01 a 08

DCOUNT Syntax ndi Arguments

© Ted French

Yopangira ntchito ya DCOUNT ndi:

= DCOUNT (ndondomeko, malo, zoyenera)

Zonsezi zimakhala ndi mfundo zitatu zofanana:

02 a 08

Chitsanzo Pogwiritsira Ntchito DCOUNT Ntchito Yophatikiza - Kugwirizana ndi Chitsanzo Chokha

Dinani pa chithunzi pamwambapa kuti muone zambiri za chitsanzo ichi.

Chitsanzo ichi chigwiritsa ntchito DCOUNT kuti chipeze chiwerengero cha ophunzira omwe analembetsa chaka choyamba cha pulogalamu yawo ya koleji.

03 a 08

Kulowa Datorial Data

Zindikirani: Maphunziro samaphatikizapo kupanga mapangidwe. Zomwe mungapange pazomwe mungapangire zolemba pamasewerawa zikupezeka mu phunziroli la Basic Excel Formatting .

  1. Lowani tebulo la deta monga momwe mukuwonera mu chithunzi pamwambapa mu maselo D1 mpaka F15
  2. Siyani selo F5 lopanda kanthu - apa ndi pamene mayendedwe a DCOUNT adzakhala
  3. Minda yamtundu m'maselo D2 mpaka F2 adzagwiritsidwa ntchito monga gawo la ndondomeko ya zovuta za ntchito

04 a 08

Kusankha Zofunikira

Kuti titenge DCOUNT kuti tiyang'ane deta ya ophunzira a zaka zoyamba ife tilowe nambala 1 pansi pa dzina la munda wa chaka mu mzere 3.

  1. Mu selo, F3 ndizoyimira zoyenera 1
  2. Mu seli ya E5 yesani mutu wonse : kuti tisonyeze zomwe tikupeza ndi DCOUNT

05 a 08

Kutchula dzina la Database

Kugwiritsa ntchito dzina lotchulidwa pazinthu zazikulu monga deta sizingakhale zosavuta kuti mulowetse mkangano umenewu kuntchito, koma zingatetezenso zolakwika chifukwa chosankha zolakwika.

Mizere yotchulidwa ndi yothandiza kwambiri ngati mumagwiritsa ntchito maselo amodzi nthawi zambiri powerengera kapena popanga ma chart kapena ma grafu.

  1. Onetsetsani maselo D6 mpaka F15 mu worksheet kuti muthe kusankha
  2. Dinani pa bokosi la dzina pamwamba pamwamba pa A A mu worksheet
  3. Lembani Kulembetsa mu bokosi la dzina kuti mupange dzina lotchulidwa
  4. Dinani pakiyi ya Kulowa pa kibokosilo kuti mutsirizitse cholowera

06 ya 08

Kutsegula Bokosi la Dialog la DCOUNT

Gulu la bokosi la ntchito limapereka njira yosavuta yolowera deta pazomwe zimagwira ntchito.

Kutsegula bokosi la bokosi la gulu lachinsinsi likugwira ntchito podalira phokoso la wizara (fx) la ntchito yomwe ili pafupi ndi barrafomu pamwamba pa tsamba - onani chithunzi pamwambapa.

  1. Dinani pa selo F5 - malo omwe zotsatira za ntchitoyi zidzawonetsedwa
  2. Dinani pa chithunzi chophatikizira foni ya foni (fx) kuti mubweretse bokosi la Kuyikira Ntchito
  3. Lembani DCOUNT mu Fufuzani pawindo la ntchito pamwamba pa dialog box
  4. Dinani pa GO kuti mufufuze ntchitoyi
  5. Bokosi la bokosilo liyenera kupeza DCOUNT ndipo lilembeni pawindo lazenera
  6. Dinani OK kuti mutsegule DCOUNT ntchito yolemba bokosi

07 a 08

Kukwaniritsa Zokambirana

  1. Dinani pa Tsamba lachidule la bokosi la bokosi
  2. Lembani dzina lazomwe akulembetsa mu mzere
  3. Dinani ku gawo la bokosi la bokosi
  4. Lembani dzina la "Year" mu mndandanda - onetsetsani kuti muli ndi zizindikiro za quotation
  5. Dinani pa mzere wofunikira wa bokosi la bokosi
  6. Onetsetsani maselo D2 kuti F3 mu tsamba lolemba kuti mulowe muyeso
  7. Dinani OK kuti mutseke DCOUNT ntchito dialog box ndi kumaliza ntchitoyi
  8. Yankho lachitatu liyenera kuoneka mu selo F5 kuchokera pa zolemba zitatu zokha - zomwe zili m'mizere 7, 10, ndi 13 - ziwonetseni wophunzira momwe analembera chaka choyamba cha pulogalamu yawo
  9. Mukasintha pa selo F5 ntchito yonse
    = DCOUNT (Kulembetsa, "Chaka", D2: F3) ikuwoneka muzenera zamatabwa pamwamba pa tsamba

Zindikirani: Ngati tifuna kupeza chiwerengero cha ophunzira omwe amalembetsa, tingagwiritse ntchito ntchito COUNT, popeza sitifunikira kufotokoza zoyenera kuti tipewe deta yomwe imagwiritsidwa ntchito ndi ntchitoyo.

08 a 08

Zolakwika Zogwira Ntchito

#Value : Amapezeka nthawi zambiri pamene maina a m'munda sanaphatikizedwe muzitsulo.

Pa chitsanzo chapamwamba, onetsetsani kuti mundawu umatchula m'maselo D6: F6 anaphatikizidwa muzinthu zolembedwera .