Yadda za a Yi amfani da Ayyukan COUNTBLANK na Google
Google Sheets, ko da yake ba kamar yadda aka yi amfani dashi ba a matsayin tsarin tayi na Microsoft Excel ko LibreOffice Calc, duk da haka yana bayar da manyan ayyukan da aka nufa don tallafawa nazarin bayanai. Ɗaya daga cikin waɗannan ayyuka- COUNTBLANK () -dada yawan yawan kwayoyin halitta a cikin zaɓin da aka zaɓa wanda ke da ƙananan lambobin.
Shafukan Wallafa na Google suna tallafawa ayyukan ƙididdiga da yawa waɗanda suke ƙidaya adadin sel a cikin zaɓin da aka zaɓa wanda ya ƙunshi wani nau'in bayanai.
Ayyukan aikin COUNTBLANK shine ƙididdiga adadin sel a cikin zaɓin da aka zaba waɗanda suke:
- M: Sel ɗin dake dauke da babu bayanai
- Blank: Cells dauke da wata mahimmanci wanda ya sake dawo da wani nau'i marar kyau
COUNTBLANK Sakamakon aiki 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 (kewayon)
Inda kewayon (wata hujja da ake buƙata) tana gano ɗayan ko fiye da kwayoyin tare da ko ba tare da bayanan da za a haɗa a cikin ƙidayar ba.
Ƙwararrayar zangon zata iya ƙunsar:
- Siffofin mutum ɗaya sunyi bayanin wuri na bayanai a cikin takardun aiki
- Hanyoyin tantancewar salula
- Sunan mai suna
Dole ne jigidar tazarar zata zama rukuni na ƙunshe na sel. Saboda COUNTBLANK ba ya yarda da jeri jeri da za a shigar da shi don maganganun jigilar , yawancin lokuta na aikin za a iya shigar da su a cikin wata takamammen su don gano yawan blank ko kullun jeri a cikin jeri biyu ko fiye.
Shigar da aikin COUNTBLANK
Fayil ɗin Shafukan Google bazai amfani da akwatunan maganganu don shigar da muhawarar aiki kamar yadda ake samu a Excel. Maimakon haka, yana da akwati na nuna kai tsaye wanda ya tashi kamar yadda aikin aikin ya shiga cikin tantanin halitta.
- Danna kan cell C2 don sa shi tantanin halitta mai aiki .
- Rubuta alammar daidai (=) bi da aikin aikin countblank- yayin da kake bugawa, akwatin zane-zane yana nuna tare da sunaye da haɗin ayyukan da suka fara tare da wasika C.
- Lokacin da sunan COUNTBLANK ya bayyana a cikin akwati, danna maɓallin shigarwa a kan keyboard don shigar da aikin aiki da kuma bude budewa (sashi madaidaiciya) zuwa cikin cell C5.
- Sanya siffofin A2 zuwa A10 don hada su a matsayin ƙwaƙwalwar kewayon aikin.
- Latsa maɓallin shigarwa a kan keyboard don ƙara maƙallin rufewa da kuma kammala aikin.
- Amsar zai bayyana a cikin cell C2.
COUNTBLANK Sauran Formulas
Maimakon COUNTBLANK, zaka iya amfani da COUNTIF ko COUNTIFS.
Ayyukan COUNTIF yana samo yawan lambobi ko kulluka a cikin layin A2 zuwa A10 kuma yana bada sakamako guda kamar COUNTBLANK. Ayyukan COUNTIFS yana dauke da muhawara biyu kuma kawai ƙididdige adadin lokutta inda aka sadu da waɗannan yanayi.
Wadannan takardun suna ba da sassaucin ra'ayi a cikin abin da kullun ko kullun dake cikin kewayo suna ƙidaya.