Mipukutu Yowonjezera Mwamsanga kapena Mizere ya Numeri mu Excel

Onjezerani zinthu mwamsanga

Kuwonjezera zipilala kapena nambala ya nambala ndi chimodzi mwazochitika zambiri m'mapulogalamu apamwamba monga Excel kapena Google Spreadsheets .

Ntchito ya SUM imapereka njira yofulumira komanso yosavuta yochitira ntchitoyi mu Excel sheet sheet.

01 ya 05

SUM Function Syntax ndi Arguments

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito ya SUM ndi:

= SUM (Number1, Number2, ... Namba2525)

Number1 - (yofunika) mtengo woyamba kuti uwerengedwe.
Mtsutso uwu ukhoza kukhala ndi deta yeniyeni yomwe ikuphatikizidwa kapena ikhoza kutanthauzira selo kumalo a deta mu tsamba la ntchito .

Number2, Number3, ... Namba255 - (zosankha) zina zowonjezera zikhoza kufikitsidwa mpaka 255.

02 ya 05

Kulowa Ntchito ya SUM Pogwiritsa ntchito zidule

Chothandizira kwambiri ndi ntchito ya SUM kuti Microsoft yakhazikitsa zidule ziwiri kuti zikhale zosavuta kugwiritsa ntchito:

• Kusintha kwachikhodi.
• AutoSUM pa tsamba la Home la Ribbon.

Zosankha zina zogwira ntchitoyi ndizo:

• Kugwiritsa ntchito bokosi la bokosi la ntchito.
• Kulowa ntchitoyo mwachangu.

03 a 05

Chidule Chachidule mu Excel Pogwiritsa Ntchito Zowonjezera Makatani

Kuphatikiza kwachinsinsi kulowa ntchito SUM ndi:

Alt = = (chizindikiro chofanana)

Chitsanzo

Masitepe otsatirawa amagwiritsidwa ntchito kulowa ntchito SUM pogwiritsa ntchito makiyi am'munsi

1. Dinani mu selo kumene ntchito SUM iyenera kupezeka.
2. Lembani ndi kugwiritsira chingwe cha Alt pa makiyi.
3. Dinani ndi kumasula chizindikiro chofanana (=) pa kibokosi popanda kumasula makiyi a Alt.
4. Tulutsani makiyi a Alt .
5. Ntchito ya SUM iyenera kulowa mu selo yogwira ntchito ndi Insertion point kapena cursor yomwe ili pakati pa awiri a mabotolo opanda kanthu.
6. Mabotolo amagwira ndondomeko ya ntchito - mndandanda wa mafotokozedwe a selo kapena manambala kuti afotokozedwe.
7. Lowani mkangano wa ntchito:
   • gwiritsani ntchito mfundo ndikusakani ndi mbewa kuti mulowetse maumboni apadera (onani Zina pansipa);
   • pogwiritsa ntchito chokopa ndi kukokera ndi mbewa kuti muwonetsetse maselo ambiri ogwirizana;
   • kulemba mu manambala kapena mafotokozedwe a selo pamanja.
8. Pomwe mkangano walowa, dinani Enter key pa kibokosi kuti mutsirize ntchitoyo;
9. Yankho liyenera kuoneka m'seri yomwe ili ndi ntchito;
10. Mukamalemba pa selo yomwe ili ndi yankho, ntchito yomaliza ya SUM imapezeka muzenera zamatabwa pamwamba pa tsamba;

Zindikirani : Pamene mutalowa mkangano wa ntchito, kumbukirani:

• maofesi omwe amalowa mwa kulemba kapena kulongosola ayenera kupatulidwa ndi makasitomala;
• chifukwa mafotokozedwe angapo a ma selo amalowa mwa kulemba, zolemba za selo ndi kumapeto kwa selo zingathe kupatulidwa ndi chida chokwanira (:)

04 ya 05

Chidule cha Dongosolo mu Excel Pogwiritsa ntchito AutoSUM

Kwa iwo amene amakonda kugwiritsa ntchito mbewa m'malo mwa kibokosi, njira yothetsera AutoSUM yomwe ili pa tabu lakumapeto kwa chingwe, monga momwe tawonetsera pa chithunzi pamwambapa, ingagwiritsidwe ntchito polowera ntchito SUM.

Gawo lotchedwa AutoSUM limatanthawuza kuti pamene atalowetsedwa pogwiritsa ntchito njirayi, ntchitoyi imasankha zomwe zimakhulupirira kuti maselo ambiri amatha kufotokozedwa ndi ntchitoyo.

Monga momwe tawonetsera pa chithunzi pamwambapa, mndandanda womwe wasankhidwa uli wamthunzi ndipo ukuzunguliridwa ndi malire odyetserako odziwika ngati oyendayenda.

Zindikirani :

• Ntchito ya SUM yapangidwa kuti ikhale pansi pa deta ya deta kapena kumapeto kwa deta.
• Ngati ntchito ya SUM imalowa pamalo osakhala awiriwa, maselo ambiri osankhidwa ngati ndondomeko ya ntchito sangakhale olakwika.
• Kuti musinthe mawonekedwe osankhidwa, gwiritsani ntchito ndondomeko ya mouse kuti muwonetsere maulendo oyenera musanatsegule fungulo lolowamo kuti mukwaniritse ntchitoyi

Kugwiritsa ntchito AutoSUM:

1. Dinani mu selo komwe ntchitoyo iyenera kukhala;
2. Onetsetsani chizindikiro cha AutoSUM pamtambo;
3. Ntchito ya SUM iyenera kulowetsedwa mu selo yogwira ntchito ndi zikhalidwe zosiyanasiyana kuti zifotokozedwe;
4. Onetsetsani kuti zowzungulira - zomwe zingapangitse kukangana kwa ntchitoyo ndi zolondola;
5. Ngati mtunduwo uli wolondola, lowetsani mu Enter key pa makiyi kuti mukwaniritse ntchitoyo;
6. Yankho lidzawonetsedwa mu selo komwe ntchitoyi inalowa;
7. Mukasindikiza selo liri ndi yankho, ntchito yomaliza ya SUM ikuwoneka mu barra ya fomula pamwamba pa tsamba.

05 ya 05

Pogwiritsa ntchito Bokosi la Kugwiritsa Ntchito la SUM

Ntchito zambiri mu Excel zingalowetsedwe pogwiritsa ntchito bokosi la malingaliro , zomwe zimakulowetsani kuti mulowetse zifukwa za ntchitoyo pamzere wosiyana. Bokosili likutengeranso mawu ogwiritsira ntchito - monga abambo oyamba ndi omaliza komanso makasitomala omwe amatsutsana.

Ngakhale kuti manambala amatha kulumikizidwa mwachindunji mumakambirano, ndibwino kuti mulowetse deta m'maselo ogwirira ntchito ndikulowa ma selo monga zifukwa za ntchitoyi.

Kulowa ntchito SUM pogwiritsa ntchito bokosi la bokosi:

1. Dinani mu selo komwe zotsatira zidzawonetsedwa.
2. Dinani pa Fomu tab ya menyu yowonjezera.
3. Sankhani Math & Trig kuchokera ku riboni kuti mutsegule ntchito yolemba pansi.
4. Dinani pa SUM mu mndandanda kuti mubweretse bokosi lazokambirana la ntchitoyo;
5. Mu bokosi la bokosi, dinani pa Number1 mzere.
6. Onetsetsani osachepera selo kapena zolemba zambiri.
7. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi.
8. Yankho liyenera kuoneka mu selo losankhidwa.