Mukamagwira ntchito zina pochita ndi tebulo, kungakhale kofunikira kuwerengera maselo odzaza ndi deta. Excel imapereka izi pogwiritsa ntchito zida zomangidwa. Tiyeni tiwone momwe mungagwiritsire ntchito ndondomeko mwatsatanetsatane.
Kuwerengera kwamaselula
Ku Excel, kuchuluka kwa maselo omwe amadzaza amatha kuwoneka pogwiritsa ntchito cholembera pa bar kapena ngati pali zinthu zingapo, zomwe zimawerengera zinthu zomwe zimadzazidwa ndi mtundu winawake wa data.
Njira 1: counter pa bar
Njira yosavuta kuwerengera maselo okhala ndi data ndikugwiritsa ntchito zidziwitso kuchokera pa counter, yomwe ili kumanja kwa batani yaimanzere kumanzere kwa mabatani osinthira mawonekedwe a Excel. Ngakhale mtundu umasindikizidwa papepala pomwe zinthu zonse zilibe kanthu kapena ndi imodzi yokha yomwe ili ndi phindu, chizindikirocho chimabisidwa. Wotsatsira amangowoneka pomwe maselo awiri kapena kupitirira opanda kanthu amasankhidwa, ndipo amawonetsa manambala awo pambuyo pa mawu "Kuchuluka".
Koma, ngakhale chida ichi chimathandizidwa ndi kusakhalitsa, ndipo chimangodikirira wosuta kuti awunikire zina, nthawi zina amatha kulumala pamanja. Kenako funso la kuphatikizika limakhala loyenerera. Kuti muchite izi, dinani kumanja pa batani yaudindo komanso mndandanda womwe ukuoneka, yang'anani bokosi pafupi "Kuchuluka". Pambuyo pake, wotsutsa adzawonetsedwanso.
Njira 2: ntchito COUNT
Chiwerengero cha maselo odzazidwa chimatha kuwerengeka pogwiritsa ntchito NT. Zimasiyana ndi njira yakale chifukwa zimakupatsani mwayi wowerengera mtundu wina mu khungu lina. Ndiye kuti, kuti tiwone zambiri, malowo sangafunikire kugawidwa pafupipafupi.
- Sankhani malo omwe amawerengetsera akuwonetsedwa. Dinani pachizindikiro "Ikani ntchito".
- Windo la Ntchito Wizard limatsegulidwa. Tikuyang'ana chinthu mndandanda SCHETZ. Pambuyo polemba dzinali, dinani batani "Zabwino".
- Windo la mkangano liyamba. Zotsutsana pamtunduwu ndizotchulira ma cell. Ulalo wolumikizana ungathe kukhazikitsidwa pamanja, koma ndibwino kuyika chikhazikitso mkati "Mtengo1"komwe mukufuna kuyika data, ndikusankha malo omwe ali ofanananira pa pepalalo. Ngati mukufuna kuwerengera maselo odzazidwa m'mizere ingapo yosiyanitsidwa wina ndi mnzake, ndiye kuti olumikizana a lachiwiri, lachitatu komanso lotsatira ayenera kulowa m'magawo omwe amatchedwa "Mtengo2", "Mtengo3" etc. Data yonse ikalowetsedwa. Dinani batani "Zabwino".
- Ntchitoyi ikhoza kuthandizidwanso mumaselo kapena mzere wa fomula, kutsatira malangizo awa:
= COUNT (mtengo1; mtengo2; ...) - Fomula italowetsedwa, pulogalamu yomwe idasankhidwa kale imawonetsa zotsatira za maselo odzazidwa amtunduwo.
Njira 3: COUNT ntchito
Kuphatikiza apo, kuwerengera maselo odzazidwa mu Excel palinso kuwerengera kogwira ntchito. Mosiyana ndi njira yakale, imangowerengera maselo omwe amadzaza ndi manambala.
- Monga momwe zinaliri m'mbuyomu, sankhani foni yomwe pulogalamuyo idzaonetsedwenso momwemo muziyendetsa Ntchito Wizard. Mmenemo timasankha wogwiritsa ntchitoyo ndi dzinalo "ACCOUNT". Dinani batani "Zabwino".
- Windo la mkangano liyamba. Zotsutsana ndizofanana ndikugwiritsa ntchito njira yapita. Udindo wawo umawonetsedwa kwa maselo. Timayika zolumikizira zam'magawo patsamba lomwe muyenera kuwerenga kuchuluka kwa maselo odzaza ndi kuchuluka kwa manambala. Kanikizani batani "Zabwino".
Pakuwongolera bukhuli, timatsata zolemba zotsatirazi:
= COUNT (mtengo1; mtengo2; ...) - Pambuyo pake, m'dera momwe fomiyi ili, kuchuluka kwa maselo odzazidwa ndi kuchuluka kwa manambala kudzawonetsedwa.
Njira 4: ntchito ya COUNTIF
Ntchitoyi imakupatsani kuwerengera osati kuchuluka kwa maselo odzazidwa ndi manambala, koma okhawo omwe amafanana ndi chikhalidwe china. Mwachitsanzo, ngati mungayike "
- Mukasankha foni kuti muwonetse zotsatira ndikuyambitsa Ntchito Wizard, sankhani kulowa "COUNTIF". Dinani batani "Zabwino".
- Windo la mkangano likutseguka. Ntchitoyi ili ndi mfundo ziwiri: magawo omwe maselo amawerengedwa, ndi choyimira, ndiye kuti, chikhalidwe chomwe takambirana pamwambapa. M'munda "Zosintha" lowetsani zolumikizira za malo omwe akonzedwedwa, komanso m'munda "Mundende" lowetsani zofunikira. Pambuyo pake, dinani batani "Zabwino".
Pazowongolera pamanja, template ili motere:
= COUNTIF (mtundu; chitsimikiziro) - Pambuyo pake, pulogalamuyo imawerengera maselo odzazidwa amitundu yosankhidwa, yomwe ikugwirizana ndi zomwe zafotokozedwazo, ndikuziwonetsa pamalo omwe afotokozedwera m'ndime yoyamba ya njirayi.
Njira 5: COUNTIF ntchito
Wogwira ntchito ku COUNTIF ndi mtundu wapamwamba wa ntchito ya COUNTIF. Amagwiritsidwa ntchito mukafuna kufotokozera mawonekedwe ophatikizira amodzi pamitundu yosiyanasiyana. Pazonse, mungathe kufotokozera mpaka 126 mikhalidwe.
- Timasankha khungu lomwe zotsatira zake zidzawonetsedwa ndikuyendetsa Ntchito Wizard. Tikuyang'ana chinthu mmenemo "COUNTILES". Sankhani ndikudina batani. "Zabwino".
- Windo la mkangano likutseguka. Zowonadi, zotsutsana za ntchito ndi zofanana ndi zapita - "Zosintha" ndi "Mkhalidwe". Kusiyanitsa kokhako ndikuti pamakhala magawo ambiri ndi magawo ofanana. Lowetsani ma adilesi amtundu ndi zofananira, kenako dinani batani "Zabwino".
Syntax yantchitoyi ndi motere:
= COUNTIME (condition_range1; condition1; condition_range2; condition2; ...) - Pambuyo pake, ntchito imawerengera maselo odzazidwa a magulu omwe adalankhulidwa, omwe amafanana ndi omwe akhazikitsidwa. Zotsatira zake zikuwonetsedwa pamalo omwe adadziwika kale.
Monga mukuwonera, kuwerengera kosavuta kwa kuchuluka kwa maselo odzazidwa m'mitundu yosankhidwa kungawonedwe mu bar ya Excel. Ngati mukufuna kuwonetsa zotsatira zake pamalo ena pepalalo, ndi zina zowerengera, makamaka pamalingaliro ena, pamenepa ntchito zapadera zidzakuthandizani.
