Count Blank okanye ezingenanto ezingekho kwii-Google Spreadsheets

Indlela yokusebenzisa umsebenzi we-Google BREAKBLANK Sheet Sheet

AmaSpredishithi eGoogle, nangona kungenjalo ngokuxhaswa ngokupheleleyo njengenguqulo yedeskithophu ye-Microsoft Excel okanye i-LibreOffice Calc, kodwa unikezela ngemisebenzi ekhethekileyo ekujoliswe ekuxhaseni uhlalutyo lwedatha. Enye yale mi sebenzi- COUNTBLANK () -buyisela inani lamaseli kwindawo ekhethiweyo enexabiso elingenanto.

I-Google Spreadsheets isekela imisebenzi embalwa yokubala ebala inani leeseli kwindawo ekhethiweyo equle uhlobo oluthile lwedatha.

Umsebenzi we- COUNTBLANK umsebenzi ubala inani leeseli kwibanga ekhethiweyo:

• Akukho nto: Iiseli ezingenayo idatha
• I-Blank: Iiseli eziqulethe ifom ebuyisela into engenanto okanye engenanto

I-COUNTBLANK ye-Syntax yeMisebenzi kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .

I-syntax yomsebenzi we-COUNTBLANK yile:

= COUNTBLANK (ububanzi)

Apho uluhlu (imbambano efunekayo) lubonisa enye okanye iiseli ezingaphezulu okanye ngaphandle kwedatha ukuba zifakwe kwibala.

Ingxabano yoluhlu ingaqukatha:

• Iingqamana zesithenjwa somntu ngamnye kwindawo yokusebenza kwiphepha lokusebenzela
• Uludwe lweetekethi zeeseli
• Uluhlu o luthetha

Ingxabano yoluhlu kufuneka ibe liqela elithintekayo leeseli. Ngenxa yokuba i-COUNTBLANK ayivumeli ukuba kubekho amanani amaninzi angeniswa kwingxabano yoluhlu , iziganeko ezininzi zomsebenzi zingangeniswa kwifomula enye ukufumana inani leenanto ezingenanto okanye ezingenalutho kwimigangatho emibini okanye engaphelelanga.

Ukufaka umsebenzi we-COUNTBLANK

I-Google Spreadsheets ayisebenzisi ibhokisi yencoko yababini yokufaka iingxoxo zomsebenzi njengoko zifumaneka kwi-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

1. Cofa kwiseli C2 ukuze wenze iseli esebenzayo .
2. Thayipha uphawu olulinganayo (=) olulandelayo lilandelwe igama lomsebenzi wenombolo- njengoko uthayipha, ibhokisi ebonisa ngokuzenzekelayo ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta C.
3. Xa igama COUNTBLANK livela kwibhokisi, cinezela ukhiye wokungena kwikhibhodi ukufaka igama lomsebenzi kunye nabazali abavulekileyo (ibhokisi elijikelezayo) kwi-cell C5.
4. Phakamisa iiseli ezi-A2 ukuya ku-A10 ukuze uzibandakanye njengengxabano yesigaba somsebenzi.
5. Cinezela ukhiye wokungena kwibhodibhodi ukongeza ii-parenthesis zokuvala uze uqedele umsebenzi.
6. Impendulo iya kubonakala kwiseli C2.

COUNTBLANK Iifomula eziNye

Endaweni ye-COUNTBLANK, ungasebenzisa COUNTIF okanye COUNTIFS.

Umsebenzi we-COUNTIF ufumana inani elingenanto okanye elingenalutho kwi-A2 ukuya ku-A10 kwaye linika iziphumo ezifanayo njenge-COUNTBLANK. Umsebenzi we-COUNTIFS uqulethe iimbambano ezimbini kwaye zibala kuphela inani lezimo apho zombini iimeko zidibene khona.

Ezi fomula zinikeza ukuguquguquka ngakumbi kwizinto ezingenanto okanye ezingenalutho kwiiseli ezibalwayo.