Momwe mungawerengere ndalamazo

Pa nthawi yogwira ntchito mu Microsoft Excel, nthawi zambiri mumafunikira kulimba muzambiri ndi zingwe za matebulo, ndikungodziwa kuchuluka kwa maselo. Pulogalamuyi imapereka zida zingapo kuti zithetse nkhaniyi. Tiyeni tiwone momwe mungawerengere kuchuluka kwa Microsoft Excel.

Anisomyani.

Chida chodziwika bwino komanso chosavuta kudziwa kuchuluka kwa deta mu maselo mu Microsoft Excel mu Microsoft. Pofuna kuwerengera ndalamazi mwanjira iyi, dinani khungu lopanda kanthu kapena cell, ndipo, mukakhala mu "nyumba", kanikizani "Autoomm".

Kulowa munthawi ya autosumma kuti muwerenge ndalamazo mu tebulo la Microsoft Excel

Pulogalamuyi imawonetsa njirayo m'chipindacho.

Syntax ya autosumma formula mu tebulo la Microsoft Excel

Kuti muwone zotsatira zake, muyenera dinani batani la Lowetsani pa kiyibodi.

Zotsatira za kuwerengetsa ndalamazo pogwiritsa ntchito njira yodzionetsera mu tebulo la Microsoft Excel

Mutha kuchita komanso mosiyana. Ngati tikufuna kuwerengera kuchuluka kwa mzere wonse kapena mzere wonse, koma mtundu winawake, ndiye kuti timagawa mitundu iyi. Kenako dinani batani lodziwika bwino la batani la "AVOSINE".

Kubwezeretsana kwa Makhalidwe patebulo pogwiritsa ntchito Msiri Msiri Mkati mwa Microsoft Excel

Zotsatira zake zimawonetsedwa nthawi yomweyo.

Chiwerengero cha zomwe zili mu tebulo mzere wawerengedwa mu Microsoft Excel

Choyipa chachikulu chowerengera ndi kudzidalira ndikuti kumakulolani kuwerengera kuchuluka kwa sewero mu mzere kapena mzere umodzi. Koma kuchuluka kwa deta yomwe ili m'mitundu ingapo ndi zingwe sizingawerengeredwe mwanjira iyi. Kuphatikiza apo, ndi icho, ndizosatheka kuwerengera kuchuluka kwa maselo angapo kutalimodzi.

Mwachitsanzo, timawonetsa ma cell, ndikudina batani la "avosin".

Kubwezeretsanso kwa Mizere Amitundu Ambiri ya Microsoft Excelfiet

Koma chophimba sichinawonekere kuchuluka kwa maselo onsewa, koma kuchuluka kwa mzere uliwonse kapena mizere iliyonse mosiyana.

Kuchuluka kwa mizere ingapo ya tebulo kumawerengeredwa mu Microsoft Excel

Ntchito "Sums"

Kuti muwone kuchuluka kwa mitundu yonse kapena zingapo data ya Arrays ku Microsoft Excel, pali "Supu". Kuti tigwiritse ntchito, timatsindika khungu lomwe tikufuna kuwonetsedwa, ndikudina batani la "Inter Love", lomwe lili kumanzere kwa chingwe cha formula.

Pitani mukagwiritse ntchito kuchuluka kwa ndalama zomwe zili mu tebulo la Microsoft Excel

Mtsogoleri wa ntchito ya neizard. Pa mndandanda wa ntchito zomwe tikufuna ntchito ya "Sums". Tikutsindika, ndikudina batani la "OK".

Sankhani formula kuti muwonjezere Microsoft Excel ku Microsoft Provitalsheet

Mu ntchito za zotsutsana za ntchitoyo, timayambitsa magwiridwe a maselo omwe ndalama zomwe zimawerengedwa. Zachidziwikire, kulowa mogwirizana ndi zovomerezeka, kotero kudina batani lomwe lili kumanzere kwa gawo lolowera data.

Onjezerani mfundo za formula form ntchito mu tebulo la Microsoft Excel

Pambuyo pa zenera ili, malingaliro a ntchito adawonongeka, ndipo titha kusankha maselo amenewo, kapena maselo a maselo amenewo, kuchuluka kwa zomwe tikufuna kuwerengera. Pambuyo pa gululi lidagawidwa, ndipo adilesi yake idawonekera m'munda wapadera, dinani batani kumanzere kwa gawo ili.

Kugwira ntchito ndi zenera lotsutsa kuti muwerenge ndalamazo mu tebulo la microsoft

Timabweranso mu zenera la ntchito. Ngati mukufuna kuwonjezera data ina iliyonse, timabwereza zomwe tatchulazi, koma m'munda ndi "nambala 2". Ngati ndi kotheka, mutha kulowa ma adilesi a chiwerengero chopanda malire cha array. Pambuyo pa ntchito zonse zomwe zimasindikizidwa, kanikizani batani la "OK".

Kuonjezera zotsutsana kuti muwerenge ndalamazo mu tebulo la Microsoft Excel

Pambuyo pake, m'chipindacho chomwe tidatulutsa zotsatira zake, kuchuluka kwa maselo awa kumawonetsedwa.

Zotsatira zowerengera ndalamazo pogwiritsa ntchito mkangano wa ntchito mu Microsoft Excel

Kugwiritsa ntchito formula

Kuchuluka kwa deta mu maselo mu Microsoft Excessel amathanso kuwerengedwa pogwiritsa ntchito njira yosavuta yowonjezera. Kuti tichite izi, timagawa khungu momwe ndalama ziyenera kukhala, ndikuyika chikwangwani "=". Pambuyo pake, dinani pa cell iliyonse, kwa omwe muyezo womwe muyenera kuwerengera. Adilesi ya cell itawonjezedwa ndi chingwe cha fomula, kulowa "" "chizindikiro cha kiyibodi, ndipo motero mutalowa magwiridwe antchito aselo iliyonse.

Kudziletsa kwa formula kuti muwerengere ndalamazo mu Microsoft Excel

Ma adilesi a maselo onse alowa, timadina batani la Enter pa kiyibodi. Pambuyo pake, kuchuluka kwa deta yomwe idalowetsedwa imawonetsedwa mu selo.

Zotsatira zakuwerengera ndalamazo pogwiritsa ntchito formula mu Microsoft Excel

Choyipa chachikulu cha njirayi ndikuti adilesi ya khungu lililonse iyenera kuyikidwa payokha, ndipo maselo osiyanasiyana sangathe kugawidwa nthawi yomweyo.

Onani kuchuluka kwa Microsoft Excel

Komanso mu pulogalamu ya Microsoft Excel ndizotheka kuwona kuchuluka kwa maselo osankhidwa popanda kuchotsa ndalamazi. Mkhalidwe wokhawo ndi kamene kali ndi maselo onse omwe ndalama zake ziyenera kuwerengedwa ziyenera kukhala pafupi ndi mndandanda umodzi. Kuti muchite izi, ingogawana maselo, kuchuluka kwa zosowa za data izi, ndikuwona zotsatira za Purse ya Microsoft Excorl.

Onani kuchuluka kwa mfundo zosankhidwa mu tebulo mu microsoft cur bar

Monga mukuwonera, pali njira zingapo zofotokozera mwachidule deta mu pulogalamu ya Microsoft Excortl. Iliyonse mwa njirazi imakhala ndi nthawi yake yovuta komanso kusinthasintha. Monga lamulo, njira yosavuta kwambiri, yomwe siyisintha. Mwachitsanzo, mukamasankha kuchuluka pogwiritsa ntchito kesi yamsika yagalimoto, ndizotheka kugwira ntchito ndi deta yokha. Chifukwa chake, pamavuto aliwonse, wogwiritsa ntchitoyo ayenera kusankha njira yoyenera.

Momwe mungawerengere ndalamazo

Anisomyani.

Ntchito "Sums"

Kugwiritsa ntchito formula

Onani kuchuluka kwa Microsoft Excel

Werengani zambiri