Kuwerengera Maselo Osalongosoka Kapena Opanda mu Excel

Chotsani COUNTBLANK Ntchito

Excel ili ndi Ntchito zingapo Zowerengera zomwe zingagwiritsidwe ntchito kuwerengera chiwerengero cha maselo m'masankhidwe omwe ali ndi deta yeniyeni.

Ntchito ya COUNTBLANK ntchito ndikuwerengera chiwerengero cha maselo mumasankhidwe omwe ali:

• Sinthani - maselo opanda data
• Maselo osajambulidwa omwe ali ndi ndondomeko yomwe imabwezera chopanda kanthu kapena mtengo wopanda pake

Syntax ndi Arguments

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Chidule cha ntchito COUNTBLANK ndi:

= COUNTBLANK (Mtunda)

Zosiyanasiyana (zofunikira) ndi gulu la maselo ntchitoyo ndi kufufuza.

Mfundo:

• Mtsutso wa Range uyenera kukhala gulu lophatikiza la maselo.
• Popeza COUNTBLANK salola kuti miyandamiyanda ikhale yowonjezera pazitsulo za Range , zochitika zambiri za ntchito zingathe kulowetsedwa muyeso limodzi kuti mupeze chiwerengero cha maselo opanda kanthu kapena opanda kanthu m'zigawo ziwiri kapena zingapo zosagwirizana, monga momwe zasonyezedwera mzere 3 za chitsanzo pamwambapa:
  • = COUNTBLANK (A2: A10) + COUNTBLANK (B2: B10)

Chitsanzo

Mu chithunzi pamwambapa, mawonekedwe angapo omwe ali ndi COUNTBLANK ntchito amagwiritsidwa ntchito kuwerengera chiwerengero chopanda kanthu kapena chopanda kanthu m'maselo awiri a deta: A2 mpaka A10 ndi B2 mpaka B10.

Kulowa ntchito COUNTBLANK

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

1. Kujambula ntchito yowonetsedwa pamwambapa mu selo lamasewera;
2. Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito COUNTBLANK ntchito dialog box

Ngakhale kuti n'zotheka kulembetsa ntchito yeniyeni mwapadera, anthu ambiri amavutika kuti agwiritse ntchito bokosi la bokosi lomwe likuyang'anitsitsa kulowa mu syntax yolondola ya ntchitoyo.

Zindikirani: Mafomu omwe ali ndi maulendo angapo a COUNTBLANK, monga omwe amawoneka m'mizere itatu ndi inayi ya chithunzichi, sangathe kulowa pogwiritsa ntchito bokosi la bokosi, koma ayenera kulowetsedwa.

Masitepe omwe ali pansipa alowetsani ntchito COUNTBLANK yomwe ikuwonetsedwa mu selo D2 mu chithunzi pamwamba pogwiritsa ntchito bokosi lazokambirana.

Kutsegula BoxBox ya COUNTBLANK Function

1. Dinani pa selo D2 kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za ntchito zidzawonetsedwa;
2. Dinani pa Fomu tab ya riboni ;
3. Dinani pa Ntchito Zambiri> Chiwerengero kuti mutsegule ntchito yolemba pansi;
4. Dinani pa COUNTBLANK m'ndandanda kuti mubweretse bokosi lazokambirana;
5. Dinani pa Range line mu dialog box;
6. Onetsetsani maselo A2 mpaka A10 mu tsamba lolembera kuti mulowetse maumboniwa monga ndondomeko ya Range ;
7. Dinani OK kuti mutsirize ntchitoyi ndi kubwerera ku tsamba la ntchito;
8. Yankho "3" likuwonekera mu selo C3 chifukwa pali magulu atatu osalongosoka (A5, A7, ndi A9) m'magazi A mpaka A10.
9. Mukasindikiza pa selo E1 ntchito yonse = COUNTBLANK (A2: A10) ikuwonekera pa bar barolomu pamwamba pa tsamba.

COUNTBLANK Mafomu Osakaniza

Njira zina ku COUNTBLANK zomwe zingagwiritsidwe ntchito zikuphatikizapo zomwe zikupezeka m'mizere isanu ndi iwiri mu chithunzi pamwambapa.

Mwachitsanzo, ndondomekoyi mu mzere wachisanu, = COUNTIF (A2: A10, "") , imagwiritsa ntchito COUNTIF ntchito kuti mupeze nambala ya maselo opanda kanthu kapena opanda kanthu m'magawo A2 mpaka A10 ndipo amapereka zotsatira zomwezo monga COUNTBLANK.

Momwemonso mizere sikisi ndi seveni, pambali ina, fufuzani mosapenya kapena maselo opanda kanthu m'magawande angapo ndipo muwerenge maselo omwe amakumana ndi zikhalidwe zonsezi. Mawonekedwe awa amapereka kusintha kwakukulu mu maselo opanda kanthu kapena opanda kanthu m'mabuku amawerengedwa.

Mwachitsanzo, ndondomekoyi mu mzere wachisanu ndi chimodzi, = COUNTIFS (A2: A10, "", B2: B10, "") , amagwiritsa ntchito COUNTIFS kuti apeze maselo opanda kanthu kapena opanda kanthu m'magawande angapo ndipo amawerengera maselo omwe alibe kanthu mzere womwewo wa mzere wonse-mzere seveni.

Mndandanda wa mzere 7, = SUMPRODUCT ((A2: A10 = "nthochi") * (B2: B10 = "")) , amagwiritsa ntchito SUMPRODUCT ntchito kuti awerengetse maselo okhawo omwe ali ndi ma banki muyeso yoyamba (A2 mpaka A10) ndipo opanda kanthu kapena opanda kanthu muyeso yachiwiri (B2 mpaka B10).