Momwe mungawerengere kuchuluka kwa ma cell omwe ali ndi zolemba mu Excel

Nthawi zina zimakhala zofunikira kumvetsetsa kuchuluka kwa maselo omwe ali ndi chidziwitso chilichonse. Zida za Excel zili ndi ntchito zingapo zomwe zimakulolani kuti mukwaniritse ntchitoyi. Tiyeni tiwonetse bwino, ndi zowonera, zomwe ziyenera kuchitidwa pa izi. Tidzasanthula zochitika zomwe zimafunikira kutsimikizira kuchuluka kwa ma cell omwe ali ndi chidziwitso komanso njira zomwe zili zoyenera mwa iwo.

Momwe mungawerengere kuchuluka kwa ma cell mu Excel

Kodi ndi zida zotani zomwe wogwiritsa ntchitoyo ali nazo ngati akufuna kudziwa kuchuluka kwa maselo?

1. Kauntala yapadera yomwe imawonetsa kuchuluka kwazomwe zili patsamba.
2. Gulu lazinthu zomwe zimatsimikizira kuchuluka kwa maselo omwe ali ndi chidziwitso chamtundu wina.

Wogwiritsa ntchitoyo angasankhe njira yoti agwiritse ntchito malinga ndi momwe zilili. Komanso, mutha kugwiritsa ntchito zida zingapo nthawi imodzi kuti muthetse mavuto ovuta kwambiri.

Njira 1. Kuwerengera Maselo ndi Status Bar

Iyi ndiye njira yosavuta yopezera kuchuluka kwa ma cell omwe ali ndi chidziwitso chilichonse. Kumanja kwa statusbar ndi kauntala. Itha kupezeka pang'ono kumanzere kwa mabatani osinthira njira zowonetsera mu Excel. Chizindikirochi sichimawonetsedwa ngati palibe chinthu chomwe chasankhidwa kapena palibe maselo omwe ali ndi makhalidwe. Simawonetsedwanso ngati pali selo limodzi lokha. Koma ngati mutasankha maselo awiri opanda kanthu, ndiye kuti cholembera chidzawonekera nthawi yomweyo, ndipo mukhoza kudziwa chiwerengero cha maselo omwe ali ndi chidziwitso.

Ngakhale kuti kauntalayi imatsegulidwa pa "fakitoli", nthawi zina sizingakhale. Izi zimachitika ngati wosuta wina wayimitsa kale. Kuti muchite izi, muyenera kuyimbira menyu yankhani ndikuyambitsa chinthu "Kuchuluka". Chizindikirocho chidzawonekeranso pambuyo pa izi.

Njira 2: Werengani ma cell omwe ali ndi ntchito ya COUNTA

Woyendetsa SCHETZ - njira yosavuta kwambiri yowerengera kuchuluka kwa maselo komwe kuli deta, ngati mukufuna kulemba zotsatira zomaliza mu selo lina kapena kuzigwiritsa ntchito powerengera ndi wogwiritsa ntchito wina. Ubwino wogwiritsa ntchito ntchitoyi ndikuti palibe chifukwa chowoneranso kuchuluka kwa ma cell nthawi iliyonse yomwe pali chidziwitso ngati mtunduwo ukusintha. Zomwe zili (mtengo wobwezeredwa ndi fomula) zidzasintha zokha. Kodi kuchita izo?

1. Choyamba, tifunika kusankha selo lomwe nambala yomaliza ya maselo odzazidwa idzalembedwera. Pezani batani la "Insert Function" ndikudina.
2. Tikamaliza masitepe omwe ali pamwambapa, bokosi la zokambirana lidzawonekera pomwe tifunika kusankha ntchito yathu. Pambuyo kusankha, dinani "Chabwino" batani.
3. Kenako, kukambirana kolowetsa mkangano kudzawonekera. Ndi ma cell angapo kapena mwachindunji maadiresi a ma cell omwe amayenera kufufuzidwa kuti akhalepo ndikuzindikira nambala. Pali njira ziwiri zolowera pagulu: pamanja ndi automatic. Kuti musalakwitse pofotokoza ma adilesi a cell, ndi bwino kusankha mtundu woyenera mukangodina pagawo lolowera deta. Ngati maselo, omwe chiwerengero chake chiyenera kutsimikiziridwa, chili patali, m'pofunika kuwalowetsa padera, ndikudzaza minda "Value2", "Value3" ndi zina zotero.
4. Dinani OK.

N'zothekanso kulowa ntchitoyi pamanja. Kapangidwe kantchito: =COUNTA(mtengo1,value2,…).

Mukalowetsa fomuyi, dinani batani lolowera, ndipo pulogalamuyo imangowerengera zonse zofunika. Idzawonetsa zotsatira mu selo lomwelo momwe fomula inalembedwera.

Njira 3. COUNT ntchito yowerengera ma cell

Palinso woyendetsa wina wopangidwa kuti apeze kuchuluka kwa maselo. Koma kusiyana kwake ndi wogwiritsa ntchito wakale ndikuti amatha kuwerengera ma cell okhawo omwe muli manambala. Momwe mungagwiritsire ntchito izi?

1. Mofananamo ndi momwe zinalili ndi fomula yam'mbuyomu, sankhani selo pomwe fomulayo idzalembedwera ndikuyatsa Function Wizard. Kenako sankhani "ACCOUNT" ndikutsimikizira zochita zanu (dinani kumanzere pa batani la OK).
2. Kenako, zenera lolowera mkangano limawonekera. Iwo ali ofanana ndi njira yapita. Muyenera kufotokoza mtundu wina (mutha kukhala nawo angapo), kapena maulalo amaselo. Dinani "Chabwino".

Kalankhulidwe kameneka kamafanana ndi kakale. Chifukwa chake, ngati mukufuna kuyiyika pamanja, muyenera kulemba mzere wotsatirawu: =COUNT(mtengo1, mtengo2,…).

Kenako, m'dera limene ndondomekoyi yalembedwa, chiwerengero cha maselo omwe muli manambala chidzawonekera.

Njira 4. COUNT ntchito

Ndi ntchitoyi, wogwiritsa ntchito amatha kudziwa osati chiwerengero cha maselo omwe ali ndi chiwerengero cha chiwerengero, komanso omwe amakwaniritsa zofunikira zina. Mwachitsanzo, ngati muyeso ndi> 50, ndiye kuti maselo okhawo omwe nambala yoposa makumi asanu yalembedwa ndi yomwe idzaganizidwe. Mutha kufotokoza zina zilizonse, kuphatikiza zomveka. Kutsatizana kwa machitidwe ambiri ndi ofanana ndi njira ziwiri zam'mbuyo, makamaka m'magawo oyambirira. Muyenera kuyitanira ntchito wizard, lowetsani mikangano:

1. Mtundu. Awa ndi ma cell omwe cheke ndi kuwerengera zidzachitikira.
2. Criterion. Ichi ndi chikhalidwe chomwe ma cell omwe ali mumtunduwo adzawunikiridwa.

Syntax polemba pamanja: =COUNTIF(mtundu, njira).

Pulogalamuyi idzachita mawerengedwe ndikuwawonetsa mu selo momwe fomula idzalembedwera.

Njira 5: Ntchito ya COUNTIFS Kuwerengera Maselo

Ntchito yofanana ndi yapitayi, imangopereka kuwunika mwa njira zingapo. Zotsutsana zikuwonekera mu chithunzithunzi ichi.

Chifukwa chake, polemba pamanja, syntax ndi: =COUNTIFS(condition_range1, condition1, condition_range2, condition2,…).

Momwe mungawerengere kuchuluka kwa ma cell okhala ndi mawu mkati mwamitundu

Kuti muwerenge kuchuluka kwa ma cell okhala ndi mawu mkati, muyenera kuyika ntchitoyi ngati mulingo -ETEXT (kuchuluka kwa chiwerengero). Ntchito yomwe mndandanda wayikapo ikhoza kukhala iliyonse mwazomwe zili pamwambapa. Mwachitsanzo, mukhoza kugwiritsa ntchito SCHETZ, pomwe m'malo mosiyanasiyana timalowetsa ntchito yomwe imanena za izi ngati mkangano. Choncho, palibe chovuta kudziwa chiwerengero cha maselo omwe ali ndi malemba. Ndikosavuta kuwerengera kuchuluka kwa maselo omwe ali ndi mtengo.