Kuverenga Mabhenekeri kana Asina Mhedziso mu Excel

Excel COUNTBLANK Basa

Excel ine mabasa mazhinji ekuverengera ayo anogona kushandiswa kuverenga nhamba yemasero mumutsetse wakasarudzwa ane ruzivo rwemhando yakasiyana.

Basa rebasa re COUNTBLANK nderekuverenga nhamba yemasero muurongwa hwakasarudzwa izvo ndezvi:

• Empty - masero asina data
• Izvo zvisina kuchena - masero ane chinyorwa chinodzorera chinhu chisina chinhu kana chisina chakanaka

Syntax uye Arguments

Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .

Izwi rechiito che COUNTBLANK basa nderekuti:

= COUNTBLANK (Range)

Rwendo (runodikanwa) ndiro boka remasero basa riri kutsvaga.

Notes:

• Range nharo yeRange inofanira kunge iri boka rinogutsa remasero.
• Sezvo COUNTBLANK isingabvumiri mitsara yakawanda kuti iongorwe muRange argument, mitambo yakawanda yebasa inogona kupindirwa mune imwe fomu yekuwana nhamba yemasero asina kujeka kana asina chinhu mumatanda maviri kana akawanda asingasviki, sezvinoratidzwa mumutsara 3 wemuenzaniso uri pamusoro apa:
  • = COUNTBLANK (A2: A10) + COUNTBLANK (B2: B10)

Muenzaniso

Mumufananidzo uri pamusoro, mazita akawanda ane COUNTBLANK basa anoshandiswa kuverenga nhamba dzisina ruvara kana dzisina chinhu masero muzvikamu zviviri zve data: A2 kusvika A10 uye B2 kusvika B10.

Kupinda basa re COUNTBLANK

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana rinoratidzwa pamusoro apa mumusero webasa;
2. Kusarudza basa uye nharo dzaro kushandisa COUNTBLANK basa dialog box

Kunyange zvazvo zvichibvira kungonyora basa rakakwana mumunhu, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi iro rinotarisa kupinda mune syntax yakakodzera yebasa racho.

Cherechedza: Mazana ane mienzaniso yakawanda ye COUNTBLANK, yakadai seaya inowanikwa mumiganhu mitatu neyechina yemufananidzo, haigoni kupinda achishanda nebhokisi rebhokisi rebasa, asi inofanira kuiswa manyore.

Matanho ari pasi apa anopinda mubasa re COUNTBLANK rinoratidzwa muchitokisi D2 mumufananidzo pamusoro apa uchishandisa bhokisi rebasa rebasa.

Kuvhura bhokisi reDynamic Function COUNTBLANK

1. Dzvanya pane cell D2 kuti iite iyo inoshanda masero - iyi ndiyo iyo migumisiro yemabasa icharatidzwa;
2. Dzvanya paMafomu tab yebhoni ;
3. Dzvanya paMamwe Mabasa> Nyaya yekuvhura basa rinoderedza pasi;
4. Dzvanya pa COUNTBLANK munyore kuunza bhokisi rebasa rebasa;
5. Dzvanya paRange line mubhokisi rebhokisi;
6. Simbisai masero A2 kusvika kuA10 mune pepa rekushandisa kuti uise zvinyorwa izvi seRange argument;
7. Dzvanya OK kuti upedze basa uye dzokera kubheji rekushanda;
8. Mhinduro "3" inowanikwa muchitokisi C3 nokuti pane matatu asina masero masere (A5, A7, uye A9) mumutsetse A kusvika kuA10.
9. Paunenge uchinge uri pa cell E1 basa rakakwana = COUNTBLANK (A2: A10) inowanikwa mubhairi yepamusoro pane pepa pepaji.

COUNTBLANK Alternative Formulas

Zvimwe zvinoshandiswa ku COUNTBLANK zvinogona kushandiswa zvinosanganisira avo vakaratidzwa mumitsara mashanu kusvika kune manomwe mumufananidzo uri pamusoro.

Semuenzaniso, rondedzero mumutsara wechishanu, = COUNTIF (A2: A10, "") , inoshandisa COUNTIF basa kuwana nhamba yemasero asina kujeka kana asina chinhu mukati meA2 kusvika A10 uye anopa mhinduro imwechete se COUNTBLANK.

Nzira iyo mumitsara mitanhatu neyechinomwe, kune rumwe rutivi, tsvaga isina chinhu kana masero asina chinhu mumakero akawanda uye uverenge iwo masero anosangana nemamiriro ose maviri. Aya mazano anowedzera kuchinja mune izvo zvisingabviri kana masero asina chinhu mukati mehutano anoverengwa.

Semuenzaniso, maitiro mumutsara wechitanhatu, = COUNTIFS (A2: A10, "", B2: B10, "") , anoshandisa COUNTIFS kuti awane masero asina chinhu kana asina chinhu mumatunhu akawanda uye anongorara aya masero asina mahwendefa asina chinhu musara mumwechete wezvikamu zviviri-mutsara wechinomwe.

Chirevo mumutsara wechinomwe, = SUMPRODUCT ((A2: A10 = "bhanana") * (B2: B10 = "")) , anoshandisa SUMPRODUCT basa kuverenga chete aya masero muzvikamu zvakasiyana-siyana zvinosangana nemamiriro maviri-eine mabhanana mumutsetse wekutanga (A2 kusvika kuA10) uye isina chinhu kana isina chinhu mumutsara wechipiri (B2 kusvika B10).