Zamkatimu
Summation ndi ntchito yodziwika bwino ya masamu mu Excel. Tiyerekeze kuti tili ndi mndandanda wa katundu patebulo, ndipo tiyenera kupeza mtengo wake wonse. Kuti muchite izi, muyenera kugwiritsa ntchito SUM. Kapena kampaniyo ikufuna kudziwa kuchuluka kwa magetsi kwa nthawi inayake. Apanso, muyenera kufotokoza mwachidule deta iyi.
ntchito SUM angagwiritsidwe ntchito paokha, komanso ngati chigawo cha ntchito zina.
Koma nthawi zina, tiyenera kufotokoza mwachidule mfundo zomwe zimakwaniritsa zofunikira zina. Mwachitsanzo, onjezani zomwe zili m'maselo obwerezabwereza kwa wina ndi mzake. Pankhaniyi, muyenera kugwiritsa ntchito imodzi mwa ntchito ziwiri zomwe zidzafotokozedwe mtsogolo.
Kusankhidwa kwachidule mu Excel
Chosankha chotsatira ndi sitepe yotsatira mutatha kuphunzira masamu wamba owonjezera ma values angapo. Ngati muphunzira kuwerenga ndikugwiritsa ntchito, mutha kuyandikira kukhala wamphamvu ndi Excel. Kuti muchite izi, pamndandanda wamitundu ya Excel, muyenera kupeza ntchito zotsatirazi.
SUMIF ntchito
Tiyerekeze kuti tili ndi deta yotere.
Ili ndi lipoti loperekedwa ndi nyumba yosungiramo masamba. Kutengera chidziwitsochi, tiyenera kuchita izi:
- Dziwani kuti ndi ndalama zingati zomwe zatsala m'sitolo za chinthu china.
- Werengetsani masikelo a katundu pamodzi ndi mtengo womwe ukufanana ndi malamulo ofotokozedwa ndi ogwiritsa ntchito.
Kugwiritsa ntchito SUMMESLI tikhoza kudzipatula matanthauzo enieni ndi kuwafotokoza mwachidule. Tiyeni titchule zotsutsana za wogwiritsa ntchitoyu:
- Mtundu. Awa ndi gulu la ma cell omwe amayenera kuwunikidwa kuti atsatire mfundo inayake. Pazigawozi, sipangakhale manambala okha, komanso malemba.
- Mkhalidwe. Mtsutsowu umatchula malamulo omwe deta idzasankhidwe. Mwachitsanzo, zikhalidwe zomwe zimagwirizana ndi mawu oti "Peyala" kapena manambala opitilira 50.
- Chiwerengero cha mafotokozedwe. Ngati sizikufunika, mutha kusiya njirayi. Iyenera kugwiritsidwa ntchito ngati gulu lazolemba likugwiritsidwa ntchito ngati mulingo wowunika momwe zinthu ziliri. Pankhaniyi, muyenera kufotokoza mtundu wowonjezera wokhala ndi manambala.
Kuti mukwaniritse cholinga choyamba chomwe tidakhazikitsa, muyenera kusankha selo lomwe zotsatira za kuwerengerazo zidzajambulidwa ndikulemba fomula ili pamenepo: =SUMIF(A2:A9;"Mphesa zoyera";B2:B9).
Chotsatiracho chidzakhala mtengo wa 42. Ngati tikanakhala ndi maselo angapo omwe ali ndi mtengo wa "Mphesa Zoyera", ndiye kuti ndondomekoyi idzabwezera chiwerengero cha chiwerengero cha malo onse a ndondomekoyi.
Ntchito SUM
Tsopano tiyeni tiyese kuthana ndi vuto lachiwiri. Chovuta chake chachikulu ndikuti tili ndi njira zingapo zomwe mtunduwo uyenera kukwaniritsa. Kuti muthane ndi vutoli, muyenera kugwiritsa ntchito SUMMESLIMN, omwe mawu ake amaphatikiza mfundo zotsatirazi:
- Chiwerengero cha mafotokozedwe. Apa mkangano uwu ukutanthauza chimodzimodzi monga chitsanzo chapitachi.
- Chikhalidwe 1 ndi gulu la ma cell momwe mungasankhire omwe akukwaniritsa zomwe zalongosoledwa mkangano womwe uli pansipa.
- Chomwe 1. Lamulo la mkangano wam'mbuyomo. Ntchitoyi idzasankha ma cell okhawo kuchokera pagulu 1 omwe amagwirizana ndi chikhalidwe 1.
- Chikhalidwe cha 2, chikhalidwe 2, ndi zina zotero.
Kupitilira apo, mikanganoyo imabwerezedwanso, mumangofunika kulowa motsatizana zamtundu uliwonse ndi muyezo womwewo. Tsopano tiyeni tiyambe kuthetsa vutolo.
Tiyerekeze kuti tifunika kudziwa kuchuluka kwa maapulo omwe atsala m'nyumba yosungiramo katundu, omwe amawononga ndalama zoposa 100 rubles. Kuti muchite izi, lembani fomula ili mu cell momwe chotsatira chomaliza chiyenera kukhala: =СУММЕСЛИМН(B2:B9;A2:A9;»яблоки*»;C2:C9;»>100″)
M'mawu osavuta, timasiya mndandanda wazomwezo monga momwe zinalili. Pambuyo pake, timalemba chikhalidwe choyamba ndi mtundu wake. Pambuyo pake, timayika zofunikira kuti mtengo ukhale woposa ma ruble 100.
Zindikirani nyenyezi (*) ngati mawu osaka. Zimasonyeza kuti makhalidwe ena akhoza kutsatira.
Momwe mungawerengere mizere yobwereza patebulo pogwiritsa ntchito tebulo lanzeru
Tiyerekeze kuti tili ndi tebulo loterolo. Anapangidwa pogwiritsa ntchito chida cha Smart Table. Mmenemo, timatha kuwona zobwereza zomwe zimayikidwa m'maselo osiyanasiyana.
Ndime yachitatu imatchula mitengo ya zinthu zimenezi. Tiyerekeze kuti tikufuna kudziwa kuchuluka kwa zinthu zobwerezabwereza zomwe zidzawononge ndalama zonse. Kodi ndiyenera kuchita chiyani? Choyamba muyenera kukopera deta yonse yobwereza ku gawo lina.
Pambuyo pake, muyenera kupita ku tabu "Data" ndikudina "Chotsani Zobwerezedwa".
Pambuyo pake, bokosi la zokambirana lidzawoneka momwe muyenera kutsimikizira kuchotsedwa kwa mfundo zobwereza.
Kutembenuka Kwapadera kwa Matigari
Kenako tikhala ndi mndandanda wazinthu zokhazo zomwe sizibwereza.
Tiyenera kukopera iwo ndi kupita "Home" tabu. Pamenepo muyenera kutsegula menyu yomwe ili pansi pa batani la "Insert". Kuti muchite izi, dinani muvi, ndipo pamndandanda womwe umawonekera, tipeza chinthucho "Paste Special". Bokosi la zokambirana ngati ili lidzawonekera.
Kusamutsa mzere kukhala mizati
Chongani bokosi pafupi "Transpose" ndi kumadula bwino. Chinthuchi chimasintha mizati ndi mizere. Pambuyo pake, timalemba mu selo lokhazikika ntchitoyo SUMMESLI.
Fomula m'nkhani yathu idzawoneka chonchi.
Kenako, pogwiritsa ntchito cholembera cha autofill, lembani ma cell otsalawo. Mukhozanso kugwiritsa ntchito ZONSE ZONSE kuti mufotokoze mwachidule zamtengo wapatali. Koma choyamba muyenera kukhazikitsa fyuluta ya tebulo lanzeru kuti ntchitoyo iwerengere zobwerezabwereza. Kuti muchite izi, dinani chizindikiro cha muvi chomwe chili pamutu wagawo, kenako dinani mabokosi omwe ali pafupi ndi zomwe mukufuna kuwonetsa.
Pambuyo pake, timatsimikizira zochita zathu mwa kukanikiza OK batani. Ngati tiwonjezera chinthu china kuti tiwonetsere, tidzawona kuti ndalama zonse zidzasintha.
Monga mukuwonera, mutha kuchita ntchito iliyonse mu Excel m'njira zingapo. Mutha kusankha zomwe zili zoyenera pazochitika zinazake kapena kungogwiritsa ntchito zida zomwe mumakonda kwambiri.