Kuwerengera zilembo mu foni ya Microsoft Excel

Nthawi zina zimakhala zofunikira kudziwa kuti ndi anthu angati omwe ali m'chipinda chimodzi. Zachidziwikire, mutha kungolemba pamanja, koma bwanji ngati pali zinthu zambiri ndikuwerengera ziyenera kuchitika ndi kusintha kosinthira kuzinthu zina? Tiyeni tiwone momwe angawerengere anthu omwe ali mu Excel.

Chiwerengero

Kwa kuwerengera otchulidwa ku Excel pali ntchito yapadera yotchedwa DLSTR. Ndi thandizo lake mungathe kufotokozera mwachidule omwe ali pazomwe zili papepala. Pali njira zingapo zomwe mungagwiritsire ntchito.

Njira 1: Kuwerengera Khalidwe

Pakuwerengera zilembo zonse zomwe zili m'chipindacho, timagwiritsa ntchito ntchitoyi DLSTRkotero kuti tinene, mwa "mawonekedwe oyera."

1. Sankhani pepala lomwe zotsalazo zikuwonetsedwa. Dinani batani "Lowani ntchito"ili pamwamba pa zenera kumanzere kwa barula yodula.



2. Ntchito mfiti imayamba. Tikufunafuna dzina m'menemo DLSTR ndipo dinani batani "Zabwino".



3. Kutsatira izi, zenera la mkangano limatseguka. Ntchitoyi imangokhala ndi mfundo imodzi - adilesi ya foni inayake. Komanso, ziyenera kudziwika kuti, mosiyana ndi ena onse omwe amagwira ntchito, izi sizithandiza kulowa zolumikizana ndi ma cell angapo kapena gulu. M'munda "Zolemba" pamanja lembani adilesi ya chinthu chomwe mukufuna kuwerengera otchulidwa. Itha kuchitika mosiyanasiyana, zomwe zimakhala zosavuta kwa ogwiritsa ntchito. Timayika chidziwitso mu gawo la zokangana ndikungodinira pagawo lomwe mukufuna. Pambuyo pake, adilesi yake idzawonekera kumunda. Data ikalowa, dinani batani "Zabwino".



4. Monga mukuwonera, zitatha izi, zotsatira zakuwerengera kuchuluka kwa zilembo zimawonekera pazenera.

Njira 2: kuwerengera anthu omwe ali mgulu

Kuti muwerenge chiwerengero cha anthu omwe ali mgulu kapena pagawo lina lililonse, sikofunikira kupereka mawonekedwe amtundu uliwonse payokha.

1. Timalowa m'makona akumunsi a cell ndi kakhalidwe. Chizindikiro Gwirani batani lakumanzere ndikulikoka ndikufanana ndi dera lomwe tikufuna kuwerengera anthu omwe akutchulidwa.



2. Fomula imakoperedwa kumitundu yonse. Zotsatira zake zimawonekera pansipo.

Phunziro: Momwe mungachite mosamalitsa mu Excel

Njira 3: kuwerengera zilembo zam'magawo angapo pogwiritsa ntchito totali ya auto

Monga tafotokozera pamwambapa, mkangano wa wothandizira DLSTR zolumikizana za khungu limodzi zitha kuwoneka. Koma bwanji ngati mukufunikira kuwerengera kuchuluka kwa otchulidwa angapo mwa iwo? Mwa izi, ndikosavuta kugwiritsa ntchito ntchito ya auto-sum.

1. Timawerengera kuchuluka kwa zilembo za selo lililonse, monga momwe tafotokozera m'mbuyomu.
2. Sankhani mtundu womwe manambala awonetsedwa, ndikudina batani "Ndalama"ili pa tabu "Pofikira" mumazisungidwe "Kusintha".



3. Pambuyo pake, kuchuluka kwathunthu kwa zilembo m'zinthu zonse kukuwonetsedwa mu khungu loyandikana ndi mitundu yosankhidwa.

Phunziro: Momwe mungawerengere kuchuluka kwa Excel

Njira 4: kuwerengera anthu omwe ali m'maselo angapo pogwiritsa ntchito ntchitoyo

Munjira yomwe ili pamwambapa, muyenera kuwerengera chilichonse pachinthu chilichonse pokhapokha ndikuwerengera kuchuluka kwamitundu yonse. Koma palinso njira ina yomwe mawerengedwe onse adzachitike mu imodzi yokha. Poterepa, muyenera kuyikira formula yolumikizira wa opaleshoni SUM.

1. Sankhani pepala lomwe zotsatira zikuwonetsedwa. Timalowetsa mkatimo malinga ndi template:

   = SUM (DLSTR (cell_address1); DLSTR (cell_address2); ...)



2. Pambuyo pa ntchitoyi ndi ma adilesi a maselo onse, kuchuluka kwa zilembo komwe mukufuna kuwerengera, kumayikidwa, dinani batani ENG. Kuchuluka kwa zilembo kukuwonetsedwa.

Monga mukuwonera, pali njira zingapo zowerengera anthu omwe ali m'maselo amtundu uliwonse, komanso chiwerengero chonse cha anthu omwe amalemba chilichonse. Munthawi iliyonse, ntchito iyi imachitika pogwiritsa ntchito ntchitoyo DLSTR.