Excel ine mabasa mazhinji ekuverengera ayo anogona kushandiswa kuverenga nhamba yemasero mumutsetse wakasarudzwa ane ruzivo rwemhando yakasiyana.
Basa reCOUNTA basa nderekuverenga nhamba yemasero muhutano husina chinhu - kureva kuti vane mhando yezvinyorwa zvakadai semashoko, nhamba, maitiro ekukanganisa, mazuva, mafomu, kana maBoolean .
Basa racho rinorega kukwana masero kana pasina. Kana dhidha yakawedzerwa pane imwe sero isina chinhu basa racho rinongodzokorora huwandu hwekusanganisira kuwedzera.
01 of 07
Nhamba dzeMatare Ane Mifananidzo kana Mamwe Marudzi eData neCOUNTA
COUNTA Function ya Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .
Mutsara weCOUNTA basa ndewokuti:
= COUNTA (Kukosha1, Kukosha2, ... Kukosha255)
Kukosha1 - (inodiwa) masero ane kana kuti asina data inofanira kuiswa mubhuku.
Kukosha2: Chiremera255 - (zvichida) mamwe masero okubatanidzwa muverengi. Nhamba yakawanda yezvinyorwa zvinobvumirwa ndei 255.
Kukosha kwemashoko kunogona kuva:
- mumwe sero rinorondedzerwa kune nzvimbo yedhesi iri mubhidhiro remabasa
- ruzhinji rwemasero zvinyorwa
- a name named
02 of 07
Muenzaniso: Kuverenga Makero eData neCOUNTA
Sezvinoratidzwa mumufananidzo wepamusoro, sero rinotaura nezvemasero manomwe rinosanganiswa muArguro inokosha yeCOUNTA basa.
Zvitanhatu zvakasiyana-siyana zvemashoko uye imwe seni isina chinhu inoita mararamiro kuratidzira marudzi e data achashanda neCOUNTA.
Masero anoverengeka ane zvigadzidzo zvinoshandiswa kuunza marudzi akasiyana-siyana emhando, zvakadai se:
- sero A5 - anoshandisa fomu kuti iite kukanganisa kweiyo # DIV / 0!
- sero A7 - inoshandisa fomu yekufananidza kuti iite kukosha kweBoolean TRUE .
03 of 07
Kupinda COUNTA Function
Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:
- Kunyora basa rakakwana: = COUNTA (A1: A7) muchengeti remashandi
- Kusarudza basa uye nharo dzaro kushandisa COUNTA basa dialog box
Kunyange zvazvo zvichibvira kungonyora basa rakakwana riri muruoko, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi kuti vapinde nharo dzebasa.
Matanho ari pasi apa anopinda mubasa achishandisa bhokisi rebhokisi.
04 of 07
Kuvhura Bhokisi reDhialog
Kuti uzarure COUNTA basa dialog box,
- Dzvanya pachitokisi A8 kuti uite sero rinoshandiswa - apa ndipo panoitwa COUNTA basa
- Dzvanya paMafomu tab yebhoni
- Dzvanya paMamwe Mabasa> Nyaya yekuvhura basa rinoderera pasi
- Dzvanya paCOUNTA mune urongwa kuti uzarure bhokisi rebasa rebasa
05 of 07
Kupinda Basa reMabasa
- Mubhokisi rebhokisi, tora pa Value1 line
- Simbisai masero A1 kusvika kuA7 kuti uise huwandu hwemasero echitokisi sehutano hwebasa
- Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi
- Mhinduro 6 inofanira kuonekwa muchitokisi A8 sezvo masereji matanhatu chete ari munharaunda ane data
- Paunenge uchinyora pane cell A8 yakagadziriswa formula = COUNTA (A1: A7) inowanikwa mubhairi yepamusoro pane pepa rekushanda
06 of 07
Kugadzirisa Mitezo Yemuenzaniso
- Dzvanya pane sero A4
- Tora comma ( , )
- Dhinda pikicha inopinda mubhokisi
- Mhinduro mutsara A8 inofanira kuchinja kusvika 7 sezvo sero reA4 risisisina chinhu
- Bvisa zviri mukati memusero A4 uye mhinduro muchitokisi A8 inofanira kudzokera shure kusvika 6
07 of 07
Zvikonzero zvekushandisa Bhokisi reDhialog Dialog
- Bhokisi rebhokisi rinotarisira kushandiswa kwemashoko - zvichiita kuti zvive nyore kupinda mhinduro dzebasa rimwe chete pane imwe nguva pasina kuisa mabheji kana mazana anoita sevanoparadzanisa pakati pezvikonzero.
- Nhamba dzenhare, dzakadaro A2, A3, uye A4 dzinogona kupindira mumushandisi uchishandisa kuratidza , izvo zvinobatanidza kuvhara masero akasarudzwa ane mouse kunze kwekuisa mukati. Haisi kungoreva zvinoreruka, zvinobatsira kuderedza mapurogiramu mumafomu akonzerwa ne isina kukodzera sekare zvinyorwa.