Subtotal ntchito mu Excel. Fomula, zofunikira patebulo

Zotsatira zapakatikati zomwe ziyenera kupezedwa polemba malipoti zitha kuwerengedwa mosavuta mu Excel. Pali njira yabwino yochitira izi, yomwe tikambirana mwatsatanetsatane m'nkhaniyi.

Zofunikira zomwe zimagwira pamatebulo kuti mupeze zotsatira zapakatikati

Subtotal ntchito mu Excel ndi yoyenera pamitundu ina ya matebulo. Pambuyo pake m'gawoli, muphunzira zomwe muyenera kukumana nazo kuti mugwiritse ntchito njirayi.

1. Mbale sayenera kukhala ndi maselo opanda kanthu, aliyense wa iwo ayenera kukhala ndi zina zambiri.
2. Chamutu chiyenera kukhala mzere umodzi. Kuphatikiza apo, malo ake ayenera kukhala olondola: popanda kudumpha ndi ma cell ophatikizika.
3. Mapangidwe a mutuwo ayenera kuchitidwa mosamalitsa pamzere wapamwamba, apo ayi ntchitoyo siigwira ntchito.
4. Gome lokha liyenera kuyimiridwa ndi chiwerengero chokhazikika cha maselo, popanda nthambi zowonjezera. Zikuwonekeratu kuti mapangidwe a tebulo ayenera kukhala ndi rectangle.

Mukapatuka pachofunikira chimodzi poyesa kugwiritsa ntchito "Zotsatira zapakatikati", zolakwika zidzawonekera mu selo lomwe lasankhidwa kuti muwerengere.

Momwe subtotal ntchito imagwiritsidwira ntchito

Kuti mupeze zofunikira, muyenera kugwiritsa ntchito ntchito yofananira, yomwe ili pamwamba pa pepala la Microsoft Excel pamwamba pa gulu.

1. Timatsegula tebulo lomwe limakwaniritsa zofunikira zomwe tafotokozazi. Kenako, dinani pa tebulo selo, kumene tidzapeza zotsatira zapakatikati. Kenako pitani ku tabu ya "Data", mugawo la "Structure", dinani "Subtotal".

2. Pazenera lomwe limatsegulidwa, tiyenera kusankha parameter imodzi, yomwe ipereka zotsatira zapakatikati. Kuti muchite izi, m'gawo la "Pakusintha kulikonse", muyenera kutchula mtengo pagawo lililonse la katundu. Chifukwa chake, mtengowo umayikidwa pansi "Price". Kenako dinani batani "Chabwino". Chonde dziwani kuti m'munda wa "Ntchito", muyenera kukhazikitsa "Ndalama" kuti muwerenge bwino zapakati.

3. Mukadina batani la "Chabwino" patebulo pamtengo uliwonse, gawo laling'ono lidzawonetsedwa, lomwe likuwonetsedwa pazithunzi pansipa.

Zolemba! Ngati mwalandira kale ziwopsezo zomwe zimafunikira kangapo, ndiye kuti muyenera kuyang'ana pabokosi lakuti “Bwezerani ziwonkhetso zamakono”. Pankhaniyi, deta sidzabwerezedwa.

Mukayesa kugwetsa mizere yonse ndi chida choyikidwa kumanzere kwa mbale, mudzawona kuti zotsatira zonse zapakatikati zimakhalabe. Ndi iwo omwe mudawapeza pogwiritsa ntchito malangizo omwe ali pamwambapa.

Ma subtotals ngati formula

Kuti musayang'ane chida chofunikira chogwirira ntchito pama tabu a gulu lowongolera, muyenera kugwiritsa ntchito njira ya "Insert function". Tiyeni tikambirane njira imeneyi mwatsatanetsatane.

1. Imatsegula tebulo momwe mungafunikire kupeza zapakati. Sankhani cell yomwe zikhalidwe zapakatikati ziziwonetsedwa.

2. Kenako dinani batani la "Insert Function". Pazenera lomwe limatsegulidwa, sankhani chida chofunikira. Kuti tichite izi, mu gawo la "Category", tikuyang'ana gawo la "Full alfabetical list". Ndiye, mu "Sankhani ntchito" zenera, alemba pa "SUB.TOTALS", alemba pa "Chabwino" batani.

3. Pazenera lotsatira "Zotsutsana zantchito" sankhani "Nambala yantchito". Timalemba nambala 9, yomwe ikugwirizana ndi njira yopangira chidziwitso chomwe tikufunikira - kuwerengera ndalama.

4. Pagawo lotsatira la data "Reference", sankhani kuchuluka kwa maselo omwe mukufuna kupeza ma subtotals. Kuti musalowetse deta pamanja, mutha kungosankha ma cell omwe amafunikira ndi cholozera, kenako dinani batani Chabwino pawindo.

Zotsatira zake, mu selo losankhidwa, timapeza zotsatira zapakatikati, zomwe ndi zofanana ndi chiwerengero cha maselo omwe tinasankha ndi deta yolembedwa.. Mutha kugwiritsa ntchito ntchitoyi popanda kugwiritsa ntchito "Function Wizard", chifukwa cha izi muyenera kulowa pamanja chilinganizo: =SUBTOTALS(chiwerengero cha ma data processing, ma cell coordinates).

Tcherani khutu! Poyesera kupeza zikhalidwe zapakatikati, wogwiritsa ntchito aliyense ayenera kusankha njira yake, yomwe idzawonetsedwe ngati zotsatira zake. Zitha kukhala osati kuchuluka kokha, komanso kuchuluka kwapakati, kochepa, kokwanira.

Kugwiritsa Ntchito Ntchito ndi Kukonza Maselo Pamanja

Njira iyi imaphatikizapo kugwiritsa ntchito ntchitoyi m'njira yosiyana pang'ono. Kugwiritsa ntchito kwake kumawonetsedwa mu algorithm ili pansipa:

1. Yambitsani Excel ndikuwonetsetsa kuti tebulo likuwonetsedwa bwino papepala. Kenako sankhani selo lomwe mukufuna kupeza mtengo wapakatikati wamtengo wina patebulo. Kenako dinani batani pansi pa gulu lowongolera "Ikani ntchito".

2. Pazenera lomwe likuwoneka, sankhani gulu la "Ntchito 10 zomwe zagwiritsidwa ntchito posachedwa" ndikuyang'ana "Ziwerengero zapakatikati" pakati pawo. Ngati palibe ntchito yotereyi, ndiye kuti m'pofunika kulembera gulu lina - "Mndandanda wathunthu wa zilembo".

3. Pambuyo pakuwonekera kwawindo lowonjezera la pop-up komwe muyenera kulemba "Function Arguments", timalowetsamo zonse zomwe zinagwiritsidwa ntchito mu njira yapitayi. Zikatero, zotsatira za "Subtotals" ntchito zidzachitika chimodzimodzi.

Nthawi zina, kubisa deta zonse, kupatula zamtengo wapakatikati pokhudzana ndi mtundu umodzi wamtengo mu cell, amaloledwa kugwiritsa ntchito chida chobisala data. Komabe, muyenera kutsimikiza kuti fomula code yalembedwa molondola.

Mwachidule

Mawerengedwe a subtotal pogwiritsa ntchito ma algorithms a Excel spreadsheet amatha kuchitidwa pogwiritsa ntchito ntchito inayake, koma angapezeke m'njira zosiyanasiyana. Mikhalidwe yayikulu ndikuchita masitepe onse kuti mupewe zolakwika, ndikuwona ngati tebulo losankhidwa likukwaniritsa zofunikira.