Iwe unogona kunge uchitoziva kuti Excel inogona kuita masvomhu nenhamba. Asi waizviziva here kuti inogona zvakare kuita masvomhu pane mamwe marudzi edata? Mumwe wemienzaniso yakapfava ibasa racho COUNTA (SCHYOTZ). Basa NY inotarisa huwandu hwemasero uye inoshuma kuti mangani awo ane data. Mune mamwe mazwi, inotarisa masero asina chinhu. Ichi chimiro chinobatsira mumamiriro akasiyana-siyana.
Kana usati wamboshanda neExcel mabasa, zvino zvichave zvinobatsira kuti iwe uende kuburikidza neyakatevedzana yezvidzidzo kubva muchikamu Formulas uye Mabasa yedu Excel Tutorial yeVanotanga. Function NY inoshanda zvakafanana mushanduro dzese dzeExcel, pamwe nemamwe maspredishiti akadai seGoogle Sheets.
Funga nezvomuenzaniso
Mumuenzaniso uyu, tiri kushandisa Excel kuronga chiitiko. Takatumira kukoka kumunhu wese, uye patinowana mhinduro, tinoisa “Hongu” kana “Kwete” muchikamu. C. Sezvaunogona kuona, muchikamu C kune maseru asina chinhu, nekuti mhinduro hadzisati dzagamuchirwa kubva kune vese vakakokwa.
Kuverenga mhinduro
Tichashandisa basa NYkuverenga kuti vanhu vangani vakapindura. Muchitokisi F2 isa chiratidzo chakaenzana chinoteverwa nezita rebasa COUNTA (SCHÖTZ):
=COUNTA
=СЧЁТЗ
Sezvakaita chero rimwe basa, nharo dzinofanirwa kuvharirwa mumabharanzi. Muchiitiko ichi, isu tinongoda nharo imwe chete: huwandu hwemasero atinoda kutarisa tichishandisa basa NY. Mhinduro "Hongu" kana "Kwete" dziri mumaseru C2:C86, asi tichabatanidza mimwe mitsetse mishoma muchikamu kuitira kana tichida kukoka vanhu vakawanda:
=COUNTA(C2:C100)
=СЧЁТЗ(C2:C100)
Mushure mekutora pinda Iwe uchaona kuti makumi mashanu neshanu mhinduro dzagamuchirwa. Iye zvino kune chikamu chinonakidza: isu tinogona kuramba tichiwedzera mibairo kuspredishiti sezvatinowana mhinduro, uye basa racho rinozozviverengera zvakare mugumisiro kuti utipe mhinduro chaiyo. Edza kutaipa "Hongu" kana "Kwete" mune chero sero isina chinhu muchikamu C uye ona kuti kukosha kuri muchitokisi F2 zvachinja.
Kuverenga vakakokwa
Tinogonawo kuverenga nhamba yose yevanhu vatakakoka. Muchitokisi F3 isa iyi fomula wodzvanya pinda:
=COUNTA(A2:A100)
=СЧЁТЗ(A2:A100)
Munoona kuti zviri nyore sei? Isu tinongoda kutsanangura imwe mhando (A2: A100) uye basa racho richaverenga nhamba yemazita mumutsara. Zita rokutanga, kudzosera mhedzisiro 85. Kana iwe ukawedzera mazita matsva pazasi petafura, Excel inozoverengera otomatiki kukosha uku. Zvisinei, kana iwe ukaisa chimwe chinhu pasi pemutsara we100, iwe uchada kugadzirisa mararamiro akataurwa mubasa kuitira kuti mitsetse yose mitsva inobatanidzwa mairi.
Bonus mubvunzo!
Iye zvino tave nenhamba yemhinduro muchitokisi F2 uye nhamba yese yevakakokwa muchitokisi F3. Zvingave zvakanaka kuverenga kuti izanai muzana yevanhu vakakokwa vakapindura. Zviongorore kana uchikwanisa kunyora muchitokisi wega F4 chimiro chekuverenga chikamu cheavo vakapindura kuhuwandu hwevakakokwa sechikamu chezana.
Shandisa maserura. Isu tinoda fomula inogara ichiverengerwazve kana shanduko dzaitwa patafura.