Ukubala izinto ezingenanto okanye ezingenanto ezingekho kwi-Excel

I-Excel COUNTBLANK Umsebenzi

I-Excel inemiSebenzi yeeNombolo ezininzi ezingasetyenziselwa ukubala inani leeseli kwindawo ekhethiweyo equle uhlobo oluthile lwedatha.

Umsebenzi we- COUNTBLANK umsebenzi ukubala inani leeseli kwindawo ekhethiweyo:

• Iimpahla ezingenalutho ezingenayo idatha
• Iimpawu ezingenanto ezingenayo ifom ebuyisela into engenanto okanye engenanto

I-Syntax kunye neengxoxo

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

I-syntax yomsebenzi we-COUNTBLANK yile:

= COUNTBLANK (Range)

Uluhlu (olufunekayo) liqela leeseli umsebenzi ukukhangela.

Amanqaku:

• Ingxabano yeRange kufuneka ibe liqela elithintekayo leeseli.
• Ekubeni i-COUNTBLANK ingavumeli ukuba kubekho amanani amaninzi angeniswa kwingxabano yeRange , iziganeko ezininzi zomsebenzi zingangeniswa kwifomula enye ukufumana inani leenanto ezingenanto okanye ezingenalutho kwimigangatho emibini okanye engaphelelanga, njengoko kuboniswe kumqolo 3 umzekelo ongentla:
  • = COUNTBLANK (A2: A10) + COUNTBLANK (B2: B10)

Umzekelo

Kumfanekiso ongasentla, iifomula eziliqela eziqukethe umsebenzi we-COUNTBLANK zisetyenziselwa ukubala inani lamagama angenanto okanye angenalutho kwimigangatho emibini yedatha: A2 ukuya ku-A10 kunye ne-B2 ukuya kwi-B10.

Ukufaka umsebenzi we-COUNTBLANK

Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:

1. Ukuthayipha umsebenzi opheleleyo uboniswe ngenhla kwiseli leshidi lomsebenzi;
2. Ukukhetha umsebenzi kunye neengxoxo zayo usebenzisa ibhokisi yencoko yebhokisi ye -COUNTBLANK

Nangona kunokwenzeka ukuba uthayiphe umsebenzi opheleleyo ngokwenza ngesandla, abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko ejongene nokufaka i-syntax efanelekileyo yomsebenzi.

Qaphela: Iifomula eziqukethe iziganeko ezininzi ze-COUNTBLANK, ezifana nezo zibonwe kwimigca emithathu nemine yomfanekiso, ayikwazi ukungena ngokusebenzisa ibhokisi yencoko yencoko yomsebenzi, kodwa kufuneka ingenwe ngesandla.

Amanyathelo angezantsi angena kwi-COUNTBLANK umsebenzi oboniswe kwiseli D2 kumfanekiso ongentla usebenzisa ibhokisi yencoko yencoko yomsebenzi.

Ukuvula i-COUNTBLANK yeBhokisi yokuSebenza yeMisebenzi

1. Cofa kwiseli D2 ukwenzela ukuba yenze iseli esebenzayo - yilapho iziphumo zomsebenzi ziza kuboniswa;
2. Cofa kwiThebhu yefomula yerbhoni ;
3. Cofa kwiMisebenzi Engakumbi> Isatisti ukuvula uluhlu lwehla phantsi;
4. Cofa kwi- COUNTBLANK kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi;
5. Cofa kwiNqanaba lomgca kwibhokisi yencoko;
6. Phakamisa iiseli ezi-A2 ukuya ku-A10 kwiphepha lokusebenzela ukuze ufake ezi ngcaciso njengengxoxo yeRange ;
7. Cofa u-OK ukugqiba umsebenzi kwaye ubuyele kwiphepha lokusebenzela;
8. Impendulo ethi "3" ibonakala kwiseli C3 kuba kukho iiselingi ezintathu ezingenanto (A5, A7, neA9) kwi-A ukuya ku-A10.
9. Xa ucofa kwi-cell E1 umsebenzi opheleleyo = COUNTBLANK (A2: A10) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

COUNTBLANK Iifomula eziNye

Ezinye iindlela eziya ku-COUNTBLANK ezingasetyenziselwa ziquka ezo ziboniswe kwimigangatho emihlanu ukuya kwi sixhenxe kumfanekiso ongentla.

Ngokomzekelo, ifom elandelana ezintlanu, = COUNTIF (A2: A10, "") , isebenzisa umsebenzi we- COUNTIF ukufumana inani leenanto ezingenanto okanye ezingenanto kwi-A2 ukuya ku-A10 kwaye inika iziphumo ezifanayo njenge-COUNTBLANK.

Ngaphandle kolunye uhlangothi, iifomula kwimigangatho yesithandathu no-sixhenxe, ngenye indlela, thola iinguli ezingenanto okanye ezingenanto kwiindawo ezininzi kwaye zibale kuphela ezo iiseli ezidibana nazo zombini iimeko. Ezi fomula zinikeza ukuguquguquka ngakumbi kwizinto ezingenanto okanye ezingenalutho kwiiseli ezibalwayo.

Ngokomzekelo, ifomula kumqolo wesithandathu, = COUNTIFS (A2: A10, "", B2: B10, "") , isebenzisa i-COUNTIFS ukufumana iinguqu ezingenanto okanye ezingenanto kwiindawo ezininzi kwaye zibala kuphela ezo iiseli ezingenazo iiseli Umqolo ofanayo weesibini zomgca-umqolo wesixhenxe.

I-formula kumqolo we sixhenxe, = I-SUMPRODUCT ((A2: A10 = "ibhanana") * (B2: B10 = "")) , isebenzisa umsebenzi we-SUMPRODUCT ukubala kuphela ezo iiseli kwiindawo ezininzi ezidibana neemeko zomibini kumqolo wokuqala (A2 ukuya ku-A10) kwaye ungenanto okanye ungenalutho kwibini lesibini (B2 ukuya ku-B10).