Kuwerengera zamtengo mu Microsoft Excel

Nthawi zina, wosuta alibe ntchito yowerengetsa kuchuluka kwa zinthu zomwe zili mgulu, koma kuwerengetsa nambala. Ndiye kuti, mwachidule, muyenera kuwerengetsa maselo angati m'ndalamayi omwe ali ndi zambiri zowerengera kapena zolemba. Ku Excel pali zida zingapo zomwe zingathetse vutoli. Tiyeni tikambirane chilichonse payekhapayekha.

Onaninso: Momwe mungawerengere chiwerengero cha mizere mu Excel
Momwe mungawerengere kuchuluka kwa maselo odzazidwa mu Excel

Ndondomeko Yowerengera Wazambiri

Kutengera zolinga za wogwiritsa ntchito, mu Excel mutha kuwerengera zonse zomwe zili mgawo, zokhazo zowerengera ndi zomwe zimagwirizana ndi gawo linalake. Tiyeni tiwone momwe tingathetsere ntchitoyi m'njira zosiyanasiyana.

Njira 1: Chizindikiro mu bar

Njira iyi ndiyosavuta kwambiri ndipo imafunikira kuchitapo kanthu. Zimakuthandizani kuti muwerenge kuchuluka kwa maselo omwe ali ndi kuchuluka kwa manambala ndi zolemba. Mutha kuchita izi pongoyang'ana pa chizindikirocho.

Kuti mumalize ntchitoyi, ingotsani batani lakumanzere ndikusankha gawo lonse momwe mukufuna kuwerengera mfundo zamtengo wapatali. Mukasankha, posankha mawonekedwe, omwe ali pansi pazenera, pafupi ndi paramenti "Kuchuluka" Chiwerengero cha mfundo zomwe zili mgulu liziwonetsedwa. Maselo odzaza ndi chidziwitso chilichonse (manambala, zolemba, deti, ndi zina) atenga nawo mbali pa mawerengedwa. Zinthu zopanda pake zidzanyalanyazidwa pakuwerengera.

Nthawi zina, chizindikiritso cha manambala sichingawonekere mu bar. Izi zikutanthauza kuti ayenera kuti ali wolumala. Kuti muulole, dinani kumanja pazenera. Makina akuwoneka. Mmenemo muyenera kuyang'ana bokosi pafupi "Kuchuluka". Pambuyo pake, kuchuluka kwa maselo odzazidwa ndi deta kuwonetsedwa mu bar yapa.

Zoyipa za njirayi zimaphatikizapo kuti zotsatira zake sizokhazikika kulikonse. Ndiye kuti mukangochotsa kusankhako, kudzazimiririka. Chifukwa chake, ngati kuli kofunikira, konzani, muyenera kujambula zotsatira pamanja. Kuphatikiza apo, pogwiritsa ntchito njirayi, ndizotheka kuwerengera maselo onse okha omwe ali ndi mfundozo ndipo ndizosatheka kukhazikitsa zowerengera.

Njira 2: Wogwiritsa ntchito ACCOUNTS

Kugwiritsa ntchito MALANGIZOmonga momwe zinalili kale, ndikotheka kuwerengera zonse zomwe zili mgulu. Koma mosiyana ndi mawonekedwe omwe ali ndi chizindikiritso cha kapamwamba, njirayi imapereka kuthekera kojambulira zotsatira zake mgawo la pepalalo.

Cholinga chachikulu cha ntchitoyo MALANGIZO, yomwe ili m'gulu la ochita ntchito, amangowerengera kuchuluka kwa maselo opanda kanthu. Chifukwa chake, titha kuzisintha mosavuta pazosowa zathu, monga, kuwerengera zigawo za mzere zodzazidwa ndi data. Syntax yantchitoyi ndi motere:

= COUNT (mtengo1; mtengo2; ...)

Pazonse, wothandizira akhoza kukhala ndi mpaka 255 yamagulu onse "Mtengo". Zotsutsazo ndizongowonetsera ma cell kapena mtundu womwe mukufuna kuwerengera zamtengo wapatali.

1. Sankhani pepala lomwe zotsatira zomaliza ziwonetsedwa. Dinani pachizindikiro "Ikani ntchito"lomwe lili kumanzere kwa baramu yamu formula.



2. Chifukwa chake tidayitana Fotokozerani Wizard. Pitani ku gulu "Zowerengera" ndikusankha dzinalo SCHETZ. Pambuyo pake, dinani batani "Zabwino" pansi pa zenera ili.



3. Timapita pawindo la mkangano MALANGIZO. Ili ndi gawo loti mulowetse mikangano. Monga kuchuluka kwamakani, amatha kufikira 255. Koma kuthetsa ntchito yomwe tayikidwa patsogolo pathu, gawo limodzi ndilokwanira "Mtengo1". Timayika cholozera mmenemo ndipo zitatha izi, ndikubowola batani lamanzere ndikanikizidwa, sankhani mzati patsamba lomwe mfundo zake mukufuna kuziwerengera. Pambuyo pazolumikizana mzere nkuwonetsedwa m'munda, dinani batani "Zabwino" pansi pa zenera zotsutsana.



4. Pulogalamuyi imawerengeredwa ndikuwonetsedwa mu foni yomwe tidasankha mu gawo loyamba la malangizowa, kuchuluka kwa zonse (zonse nambala ndi zolemba) zomwe zili mgulu lachiwuno.

Monga mukuwonera, mosiyana ndi njira yapita, njira iyi imawonetsera zotsatira zake mu pepala momwe mungasungire pamenepo. Koma mwatsoka, ntchitoyo MALANGIZO komabe, sizimalola kufotokoza zofunikira pakusankha mfundo.

Phunziro: Mfiti Yogwira Ntchito Excel

Njira 3: Wothandizira ACCOUNT

Kugwiritsa ntchito ACCOUNT kuchuluka kokha kwa manambala m'danga losankhidwa ndi amene angawerenge. Imanyalanyaza zolemba ndipo siziphatikiza zonsezo. Ntchitoyi ilinso ya gulu la ogwiritsa ntchito manambala, ngati yoyamba ija. Ntchito yake ndikuwerengera maselo mumitundu yosankhidwa, ndipo ife, mgulu lomwe lili ndi ziwerengero. Kuphatikizika kwa ntchitoyi kuli pafupifupi kofanana ndi mawu am'mbuyomu:

= COUNT (mtengo1; mtengo2; ...)

Monga mukuwonera, zotsutsana za ACCOUNT ndi MALANGIZO ndizofanana ndipo zikuyimira ma cell kapena mzere. Kusiyana kwa syntax kumangokhala mu dzina la wothandizira lokha.

1. Sankhani chinthucho papepala pomwe zotsatira zake ziwonekere. Dinani chithunzi chomwe tikudziwa kale "Ikani ntchito".



2. Pambuyo kukhazikitsa Ogwira Ntchito kusunthira ku gulu kachiwiri "Zowerengera". Kenako sankhani dzinalo "ACCOUNT" ndikudina batani "Chabwino".



3. Pambuyo pa wotsutsana wotsutsana ndiwindo wayambika ACCOUNT, iyenera kulowetsedwa m'munda wake. Pazenera ili, monga pazenera la ntchito yam'mbuyomu, mpaka minda 255 ikhoza kuperekedwanso, koma, monga nthawi yotsiriza, tikufuna imodzi yokha yomwe yatchedwa "Mtengo1". Lowani mu gawo ili zomwe zikugwirizana ndi gawo lomwe tikufunika kugwira ntchito. Timachita zonsezi monga momwe tidachitiramo izi pochita MALANGIZO: ikani cholozera m'munda ndi kusankha pagome. Pambuyo polemba adilesi yolowera kumunda, dinani batani "Zabwino".



4. Zotsatira zake ziwonetsedwa mu foni yomwe tidafotokozera zomwe zili mu ntchitoyo. Monga mukuwonera, pulogalamuyi idawerengera maselo omwe ali ndi ziwerengero. Maselo opanda kanthu komanso zinthu zomwe zili ndi zolemba sizinaphatikizidwe ziwerengero.

Phunziro: Kuwerengera ntchito ku Excel

Njira 4: COUNTIF opangira

Mosiyana ndi njira zam'mbuyomu, kugwiritsa ntchito wothandizira KULIMA limakupatsani inu kukhazikitsa mikhalidwe yomwe ikugwirizana ndi zomwe zitenge nawo mbali pakuwerengera. Maselo ena onse sadzanyalanyazidwa.

Wogwiritsa ntchito KULIMA adawerengedwa ngati gulu la ntchito za Excel. Ntchito yake yokhayo kuwerengera zinthu zopanda pake mndandanda, ndipo ife, mgulu lomwe limakwaniritsidwa. Syntax ya opaleshoni iyi imasiyana kwambiri ndi ntchito ziwiri zapitazi:

= COUNTIF (mtundu; chitsimikiziro)

Kukangana "Zosintha" Imayimiriridwa ngati cholumikizana ndi gulu linalake la maselo, ndipo ife, ndi mzati.

Kukangana "Mundende" ili ndi zomwe zanenedwa. Izi zitha kukhala nambala yeniyeni kapena chithunzi, kapena mtengo wotchulidwa ndi zizindikiro zambiri (>), zochepa (<), wosofanana (), etc.

Tiwerenge maselo angati omwe ali ndi dzinalo Nyama zili mgulu loyambirira la tebulo.

1. Sankhani chinthucho pa pepala momwe matumizidwe amapezeka. Dinani pachizindikiro "Ikani ntchito".



2. Mu Ntchito wiz sinthani gawo "Zowerengera", sankhani dzinalo KULIMA ndipo dinani batani "Zabwino".



3. Ntchito yotsutsana ndi ntchito imayambitsidwa KULIMA. Monga mukuwonera, zenera lili ndi magawo awiri omwe amagwirizana ndi zotsutsana za ntchitoyi.

   M'munda "Zosintha" momwemonso momwe tafotokozera kale koposa kamodzi, timalowa pazolumikizana za gawo loyamba la tebulo.

   M'munda "Mundende" tiyenera kukhazikitsa kuwerengera kwake. Lowetsani mawu pamenepo Nyama.

   Zomwe zili pamwambazi zikamalizidwa, dinani batani "Zabwino".



4. Wogwiritsa ntchito amawerengera ndikuwonetsa zotsatira zake pazenera. Monga mukuwonera, mzere wosankhidwa mu maselo 63 muli mawu Nyama.

Tiyeni tisinthe ntchitoyo pang'ono. Tsopano tiyeni tiwerenge kuchuluka kwa maselo omwe ali mgulu lomwelo lomwe mulibe mawu Nyama.

1. Timasankha foni momwe titulutsire zotsatira, ndipo mwa njira yomwe tafotokozayi timayitanitsa tsamba la wotsutsana KULIMA.

   M'munda "Zosintha" timalowa zolumikizana za gawo loyambirira la tebulo lomwe tidakonzamo kale.

   M'munda "Mundende" lembani mawu otsatirawa:

   Nyama

   Ndiye kuti, chitsimikizo ichi chimayika momwe tiziwerengera zinthu zonse zodzazidwa ndi data zomwe sizikhala ndi mawu Nyama. Chizindikiro "" amatanthauza mu Excel wosofanana.

   Pambuyo polowetsa izi pazenera zotsutsana, dinani batani "Zabwino".



2. Zotsatira zake zimawonetsedwa nthawi yomweyo mu cell yolankhulidwayo. Adatinso kuti mzere wosankhidwa muli zinthu 190 zokhala ndi deta zomwe mulibe mawu Nyama.

Tsopano tiyeni tipange m'ndime yachitatu ya gawoli kuwerengera kwa mitengo yonse yomwe imaposa chiwerengero cha 150.

1. Sankhani foni kuti muwonetse zotsatira ndikupita pazenera zotsutsa KULIMA.

   M'munda "Zosintha" lowetsani zolumikizana za gawo lachitatu la tebulo lathu.

   M'munda "Mundende" lembani izi:

   >150

   Izi zikutanthauza kuti pulogalamuyo imangowerenga zinthu zomwe zili ndi ziwerengero zopitilira 150.

   Chotsatira, monga nthawi zonse, dinani batani "Zabwino".



2. Pambuyo powerengera, Excel amawonetsa zotsatira mu khungu lomwe limafotokozedwa kale. Monga mukuwonera, mzere wosankhidwa uli ndi mfundo za 82 zomwe zimaposa chiwerengero cha 150.

Chifukwa chake, tikuwona kuti ku Excel pali njira zingapo zowerengetsera kuchuluka kwa mfundo mzere. Kusankhidwa kwa njira inayake kumadalira zolinga za wosuta. Chifukwa chake, cholembera pamtundu wa mawonekedwe chimakupatsani mwayi kuti muwonere kuchuluka kwa mitengo yonse yomwe ili mgawo popanda kukonza zotsatira; ntchito MALANGIZO imapereka mwayi wokonza manambala awo m'selo ina; wothandizira ACCOUNT amangowerengera zinthu zomwe zimakhala ndi manambala; ndi ntchitoyo KULIMA Mutha kukhazikitsa zovuta zina zowerengera zinthu.