Mwina mukudziwa kale kuti Excel imatha kuwerengera ndi manambala. Koma kodi mumadziwa kuti imathanso kuwerengera mitundu ina ya data? Chimodzi mwa zitsanzo zosavuta ndi ntchito COUNTA (SCHYOTZ). Ntchito COUNT imayang'ana ma cell angapo ndikuwonetsa kuti angati ali ndi data. Mwanjira ina, imayang'ana ma cell opanda kanthu. Mbali imeneyi ndi zothandiza pa zochitika zosiyanasiyana.
Ngati simunagwirepo ntchito ndi Excel, ndiye kuti zingakhale zothandiza kuti mudutse maphunziro angapo kuchokera pagawoli Mafomu ndi Ntchito athu Maphunziro a Excel kwa Oyamba. Ntchito COUNT imagwira ntchito chimodzimodzi m'mitundu yonse ya Excel, komanso ma spreadsheets ena monga Google Sheets.
Taganizirani chitsanzo ichi
Mu chitsanzo ichi, tikugwiritsa ntchito Excel kukonzekera chochitika. Tinkatumiza mawu oitanira anthu onse, ndipo tikalandira mayankho, timalemba “Inde” kapena “Ayi” m’gawoli. C. Monga mukuonera, mu gawo C pali maselo opanda kanthu, chifukwa mayankho sanalandirebe kuchokera kwa onse oitanidwa.
Kuwerengera mayankho
Tidzagwiritsa ntchito COUNTkuti awerenge kuchuluka kwa anthu omwe adayankha. Mu cell F2 lowetsani chizindikiro chofanana chotsatiridwa ndi dzina la ntchitoyo COUNTA (SCHÖTZ):
=COUNTA
=СЧЁТЗ
Mofanana ndi ntchito ina iliyonse, mikangano iyenera kutsekedwa m'makolo. Pankhaniyi, timangofunika mkangano umodzi: kuchuluka kwa maselo omwe tikufuna kuwona pogwiritsa ntchito ntchitoyi COUNT. Mayankho "Inde" kapena "Ayi" ali m'maselo c2: c86, koma tiphatikizanso mizere ingapo pamndandandawo ngati tingafune kuitana anthu ambiri:
=COUNTA(C2:C100)
=СЧЁТЗ(C2:C100)
Pambuyo kuwonekera Lowani Mudzawona kuti mayankho 55 alandilidwa. Tsopano pa gawo losangalatsa: titha kupitiriza kuwonjezera zotsatira pa spreadsheet pamene tikupeza mayankho, ndipo ntchitoyi idzawerengeranso zotsatira kuti itipatse yankho lolondola. Yesani kulemba "Inde" kapena "Ayi" mu selo iliyonse yopanda kanthu muzambiri C ndikuwona kuti mtengo mu cell F2 wasintha.
Kuwerengera oitanidwa
Tingawerengenso chiŵerengero chonse cha anthu amene tawaitanira. Mu cell F3 lowetsani fomula iyi ndikusindikiza Lowani:
=COUNTA(A2:A100)
=СЧЁТЗ(A2:A100)
Mukuona kuphweka kwake? Timangofunika kufotokoza mtundu wina (A2: A100) ndipo ntchitoyi iwerengera kuchuluka kwa mayina omwe ali pamndandanda. Dzina loyamba, kubwezera zotsatira 85. Mukawonjezera mayina atsopano pansi pa tebulo, Excel idzawerengeranso mtengowo. Komabe, ngati mulowetsa china m'munsimu mzere 100, ndiye kuti muyenera kukonza mndandanda womwe watchulidwa mu ntchitoyi kuti mizere yonse yatsopano ikhalepo.
Funso la bonasi!
Tsopano tili ndi chiwerengero cha mayankho mu selo F2 ndi chiwerengero chonse cha oitanidwa m'chipindamo F3. Zingakhale zabwino kuwerengera kuchuluka kwa anthu oitanidwa omwe adayankha. Dziyeseni nokha ngati mungathe kulemba mu cell nokha F4 ndondomeko yowerengera gawo la omwe adayankha ku chiwonkhetso cha oitanidwa monga peresenti.
Gwiritsani ntchito maumboni a cell. Timafunikira chilinganizo chomwe chidzawerengedwanso nthawi zonse pamene zosintha zapangidwa patebulo.