Excel COUNTBLANK Ayyuka
Excel yana da ayyuka da yawa waɗanda za a iya amfani dasu don ƙidaya yawan adadin sel a cikin zaɓin da aka zaɓa wanda ya ƙunshi wani nau'in bayanai.
Ayyukan COUNTBLANK aikin shine ƙidaya adadin sel a cikin zaɓin da aka zaɓa waɗanda suke:
- M - Kwayoyin da ba su da bayanai
- Blank - Kwayoyin da ke dauke da wata mahimmanci wanda ya sake dawo da komai ko ƙananan nau'in
Hadin rubutu da jayayya
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Haɗin kan aikin COUNTBLANK shine:
= COUNTBLANK (Range)
Tsarin (buƙata) shine rukuni na sel da aikin shine don bincika.
Bayanan kula:
- Dole ne gardama ta kasance wata ƙungiya mai rikici.
- Tunda COUNTBLANK ba ya ba da izinin yawan jeri da za a shigar da ita don jigidar Range , za'a iya shigar da lokuta masu yawa na aikin a cikin takamammen tsari don gano yawan blank ko kullun jeri a cikin jeri guda biyu ko fiye, kamar yadda aka nuna a jere na 3 na misali a sama:
- = COUNTBLANK (A2: A10) + COUNTBLANK (B2: B10)
Misali
A cikin hoton da ke sama, ana amfani da wasu matakai da ke ɗauke da aikin COUNTBLANK don ƙidaya yawan adadin kullun ko kullun jaka a cikin jeri guda biyu na bayanai: A2 zuwa A10 da B2 zuwa B10.
Shigar da aikin COUNTBLANK
Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:
- Rubuta cikakken aikin da aka nuna a sama a cikin sashin layin aiki;
- Zabi aikin da kuma muhawara ta amfani da akwatin maganganun COUNTBLANK
Kodayake yana yiwuwa don kawai aiwatar da cikakken aiki tare da hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu wanda ya dubi bayan shigar da haɗin rubutu daidai don aikin.
Lura: Formulas dauke da lokutta da yawa na COUNTBLANK, kamar waɗanda aka gani a cikin layuka uku da hudu na hoton, ba za a iya shiga ta amfani da akwatin maganganun ba, amma dole ne a shigar da hannu.
Matakan da ke ƙasa da rufe shigar da aikin COUNTBLANK da aka nuna a cikin dakin D2 a cikin hoton da ke sama ta amfani da akwatin maganganun aikin.
Don Bude COUNTBLANK Function Dialog Box
- Danna kan tantanin halitta D2 don sa shi tantanin halitta mai aiki - wannan shine inda za a nuna sakamakon da aikin yake;
- Danna kan Rubutun hanyoyin shafin rubutun ;
- Danna kan Ƙarin Ayyuka> Bayani na ilimin lissafin bayanai don buɗe jerin aikin sauke aikin;
- Danna kan COUNTBLANK a cikin jerin don kawo akwatin maganganu na aikin;
- Danna kan Range a cikin akwatin maganganu;
- Sanya siffofin A2 zuwa A10 a cikin takardun aiki don shigar da waɗannan nassoshi a matsayin hujjar Range ;
- Danna Ya yi don kammala aikin kuma komawa cikin takardun aiki;
- Amsar "3" ta bayyana a cell C3 saboda akwai nau'o'i guda uku (A5, A7, da A9) a cikin kewayon A zuwa A10.
- Lokacin da ka danna kan tantanin halitta E1 cikakken aikin = COUNTBLANK (A2: A10) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.
COUNTBLANK Sauran Formulas
Sauye zuwa COUNTBLANK wanda za'a iya amfani dashi sun hada da wadanda aka nuna a layuka biyar zuwa bakwai a cikin hoton da ke sama.
Alal misali, ƙirar a cikin jere biyar, = COUNTIF (A2: A10, "") , yana amfani da aikin COUNTIF don samo yawan blank ko kullun jaka a cikin kewayon A2 zuwa A10 kuma ya ba da wannan sakamakon kamar COUNTBLANK.
Kwayoyin da ke cikin layuka shida da bakwai, a gefe guda, sami kullun ko kullun a cikin jeri da yawa kuma kawai ƙidaya waɗannan kwayoyin da ke haɗu da waɗannan yanayi. Wadannan takardun suna ba da sassaucin ra'ayi a cikin abin da kullun ko kullun suke cikin kewayo suna ƙidaya.
Alal misali, ma'anar a jere na shida, = COUNTIFS (A2: A10, "", B2: B10, "") , yana amfani da COUNTIFS don gano kullun ko kullun jaka a jeri da yawa kuma kawai ƙidaya waɗannan kwayoyin da ke da sel a cikin jinsi guda biyu na jere-jere bakwai.
Maganin a jere na bakwai, = SUMPRODUCT ((A2: A10 = "ayaba") * (B2: B10 = "")) , yana amfani da aikin SUMPRODUCT kawai don ƙidaya waɗannan ƙwayoyin a jeri da yawa waɗanda suka hadu da duka sharuɗɗa-wanda ya ƙunshi ƙanshin a cikin na farko (A2 zuwa A10) kuma kasancewa komai ko komai a cikin na biyu (B2 zuwa B10).