Momwe Mungakwaniritsire Ma Columns kapena Mizere mu Mapepala a Google

Ntchito ya SUM ntchito ndi maonekedwe mu Google Mapepala

Kuwonjezera mzere kapena mizere yazithunzi ndi chimodzi mwa ntchito zomwe zimachitika pulogalamu yonse ya spreadsheet. MaSupe a Google amaphatikizapo ntchito yowonjezera yotchedwa SUM.

Mbali imodzi yabwino ya spreadsheet ndiyo mphamvu yake yosinthira ngati kusintha kumapangidwa mkati mwa maselo ofotokozedwa. Ngati deta ikuphatikizidwa isinthidwa kapena nambala ikuwonjezeka ku maselo osalongosoka, chiwerengerocho chidzasinthidwa kuti chikhale ndi deta yatsopano.

Ntchitoyi imanyalanyaza malemba - monga mitu ndi malemba - muzinthu zosankhidwa. Lowetsani ntchitoyo mwachindunji kapena mugwiritse ntchito njira yochezera pa toolbar ngakhale zotsatira zowonjezereka.

Google Spreadsheets SUM Function Syntax ndi Arguments

Chidule cha ntchito ya SUM chimatanthauzira maonekedwe a ntchitoyi, yomwe imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito ya SUM ndi:

= SUM (nambala_1, nambala_2, ... nambala_30)

Zokambirana za ntchito za SUM

Zokambirana ndizofunika zomwe ntchito ya SUM idzagwiritsa ntchito panthawiyi.

• nambala_1 - (yofunika) deta yoti ikhale ndi ntchitoyo.
• nambala_2 , ... nambala_30 - (zosankha) zina zowonjezera zikhoza kufotokozedwa kufika pa chiwerengero cha makumi asanu ndi atatu (30) kapena mndandanda ungathe kufotokozedwa ndi ntchitoyo.

Mtsutso uliwonse ukhoza kukhala nawo:

• Nambala imodzi iyenera kufotokozedwa.
• Chizindikiro cha selo chomwe chikusonyeza malo a deta mu worksheet .
• Mafotokozedwe angapo a selo kumalo a deta mu tsamba la ntchito.

Chitsanzo: Onjezerani Khola la Numeri Pogwiritsa Ntchito Ntchito SUM

Monga momwe tawonera pa chithunzi pamwambapa, chitsanzo ichi chilowetsa mafotokozedwe a maselo ku deta yambiri kuti ikhale ntchito ya SUM. Zosankhidwazo zimaphatikizapo malemba ndi masalimo opanda kanthu, onse awiri omwe amanyalanyazidwa ndi ntchitoyo.

Kenaka, nambala idzawonjezedwa ku maselo omwe alibe blank kapena ali ndi malemba. Chiwerengero cha zowerengerazo chidzasinthidwa ndikuphatikizapo deta yatsopano.

Kulowa Datorial Data

1. Lowani deta zotsatirazi mu maselo A1 mpaka A6 : 114, 165, 178, malemba.
2. Siyani selo A5 lopanda kanthu.
3. Lowetsani deta zotsatirazi mu selo A6 : 165.

Kulowa Ntchito ya SUM

1. Dinani pa selo A7 , malo omwe zotsatira za ntchito SUM ziwonetsedwe.
2. Dinani ku Insert > Ntchito > SUM mu menus kuti muike ntchito ya SUM mu selo A7 .
3. Onetsetsani maselo A1 ndi A6 kuti mulowetse deta yamtunduwu monga kukangana kwa ntchito.
4. Dinani ku key lolowamo pa khibhodi.
5. Chiwerengero cha 622 chiyenera kuoneka mu selo A7, yomwe ndi chiwerengero cha manambala omwe alowa mu maselo A1 mpaka A6.

Kusintha ntchito ya SUM

1. Lembani chiwerengero cha 200 mu selo A5 ndikusindikizira mu Enter key pa makiyi.
2. Yankho la 622 mu selo A7 liyenera kusintha mpaka 822.
3. Bwezerani deta yanu mu selo A4 ndi nambala 100 ndikusindikizira fungulo lolowani mukhiyi.
4. Yankho mu A7 liyenera kusintha mpaka 922.
5. Dinani pa selo A7 ndi utumiki wathunthu = SUM (A1: A6) ikuwoneka mu barra yazenera pamwamba pa tsamba