Cishe usuyazi kakade ukuthi i-Excel ingakwazi ukwenza izibalo ngezinombolo. Kodwa bewazi ukuthi ingakwazi nokwenza izibalo kwezinye izinhlobo zedatha? Esinye sezibonelo ezilula kakhulu umsebenzi I-COUNTA (SCHYOTZ). Umsebenzi I-COUNT ibheka ububanzi bamaseli futhi ibike ukuthi mangaki kuwo aqukethe idatha. Ngamanye amazwi, ibheka amaseli angenalutho. Lesi sici siwusizo ezimweni ezihlukahlukene.
Uma ungakaze usebenze ngemisebenzi ye-Excel, kuyoba usizo kuwe ukuthi udlule ochungechungeni lwezifundo ezivela esigabeni Amafomula kanye Nemisebenzi Isifundo sethu se-Excel sabaqalayo. Umsebenzi I-COUNT isebenza ngendlela efanayo kuzo zonke izinguqulo ze-Excel, kanye namanye amaspredishithi njenge-Google AmaSpredishithi.
Cabanga ngalesi sibonelo
Kulesi sibonelo, sisebenzisa i-Excel ukuhlela umcimbi. Sithumele izimemo kuwo wonke umuntu, futhi lapho sithola izimpendulo, sifaka “Yebo” noma “Cha” kukholamu. C. Njengoba ubona, kukholamu C kunamaseli angenalutho, ngoba izimpendulo azikatholwa kubo bonke abamenyiwe.
Ukubala izimpendulo
Sizosebenzisa umsebenzi I-COUNTukubala ukuthi bangaki abantu abaphendulile. Esitokisini F2 faka uphawu olulinganayo olulandelwa yigama lomsebenzi I-COUNTA (SCHÖTZ):
=COUNTA
=СЧЁТЗ
Njenganoma yimuphi omunye umsebenzi, izimpikiswano kufanele zifakwe kubakaki. Kulokhu, sidinga impikiswano eyodwa kuphela: ububanzi bamaseli esifuna ukuwuhlola sisebenzisa umsebenzi I-COUNT. Izimpendulo “Yebo” noma “Cha” kumaseli C2:C86, kodwa sizofaka imigqa embalwa eyengeziwe ebangeni uma kwenzeka sidinga ukumema abantu abengeziwe:
=COUNTA(C2:C100)
=СЧЁТЗ(C2:C100)
Ngemuva kokuchofoza Faka Uzobona ukuthi izimpendulo ezingama-55 sezitholiwe. Manje ngengxenye ejabulisayo: singaqhubeka sengeza imiphumela kusipredishithi njengoba sithola izimpendulo, futhi umsebenzi uzobala kabusha ngokuzenzakalelayo umphumela ukuze usinikeze impendulo efanele. Zama ukuthayipha okuthi “Yebo” noma “Cha” kunoma iyiphi iseli engenalutho kukholamu C futhi ubone ukuthi inani kuseli F2 useguqukile.
Ebala abamenyiwe
Singakwazi futhi ukubala ingqikithi yenani labantu esibamemile. Esitokisini F3 faka le fomula bese ucindezela Faka:
=COUNTA(A2:A100)
=СЧЁТЗ(A2:A100)
Niyabona ukuthi kulula kanjani? Sidinga nje ukucacisa obunye ububanzi (A2:A100) futhi umsebenzi uzobala inani lamagama kukholomu. Igama, ebuyisela umphumela 85. Uma ungeza amagama amasha ngezansi kwetafula, i-Excel izobala kabusha leli nani ngokuzenzakalelayo. Nokho, uma ufaka okuthile ngezansi komugqa we-100, uzodinga ukulungisa ububanzi obushiwo kumsebenzi ukuze kufakwe yonke imigqa emisha kuwo.
Umbuzo webhonasi!
Manje sinenani lezimpendulo kuseli F2 kanye nenani eliphelele labamenyiwe kuseli F3. Kungaba kuhle ukubala ukuthi yimaphi amaphesenti abantu abamenyiwe abaphendulile. Zihlole ukuthi uyakwazi yini ukuzibhalela esitokisini F4 ifomula yokubala isabelo salabo abaphendule enanini eliphelele labamenyiwe njengephesenti.
Sebenzisa izinkomba zeseli. Sidinga ifomula ezohlala ibalwa kabusha lapho izinguquko zenziwa etafuleni.