Nzira Yokusangana Nema Columns kana Row muGoogle Sheets

Iko kushandiswa kweSUM basa uye kuratidzira muGoogle Sheets

Kuwedzera mitsetse kana nhamba dzematare ndeimwe yezvakaitwa zvinowanzoitwa mumapurogiramu ose epadheseti. MaSpredishiti eGoogle anosanganisira yakagadzirwa mune basa rinonzi SUM.

Chimwe chinhu chakanaka chepadhesi yepamusoro ndiyo kukwanisa kwayo kugadzirisa kana kuchinja kunogadzirwa mukati mehuwandu hwemashure akapfupiswa. Kana iyo dhesi ichinyorwa ichishandurwa kana nhamba dziwedzerwa kumasero asina kuvhara, nhamba yacho ichatsvaga kuongororwa kuti inyore data itsva.

Basa racho rinorega kunyora zvinyorwa - zvakadai semisoro uye mavara-mumutsetse wakasarudzwa. Pinda basa racho pachako kana kushandisa shinje pakubhairidzi yezvigadziriswa.

Google Spreadsheets SUM Basa Rinoshanda Syntax uye Arguments

S syntax yaSUM basa inoreva kuumbwa kwebasa rinoshandiswa, iro rinosanganisira zita rebasa, mabheji, uye nharo .

Mutsara webasa reSUM ndewokuti:

= SUM (nhamba_1, nhamba_2, ... nhamba_30)

SUM Function Arguments

Nharo ndidzo maitiro ayo SUM basa raanoshandisa panguva yekuverenga kwayo.

• nhamba_1 - (inoshandiswa) data inogona kuenzaniswa nebasa racho.
• number_2 , ... number_30 - (optional) mamwe maitiro ekutapfupiswa kusvika kumakumi makumi matatu nemasere kana mitsara inogona kupfupiswa nemabasa.

Nharo imwe neimwe inogona kuva:

• Nhamba imwe chete inogona kupfupiswa.
• Tsanangudzo yesero inoratidzira nzvimbo ye data mune pepa rekushanda .
• Mhando yesero rinotaura nezve nzvimbo ye data mune pepa rekushanda.

Muenzaniso: Wedzera Koromo yeNumeri Uchishandisa Basa reSUM

Sezvinoratidzwa mumufananidzo wepamusoro, muenzaniso uyu unopinda mumasero ezvinyorwa kune ruzivo rwemashoko kuti rwubatwe basa reSUM. Rudzi rwakasarudzwa runosanganisira rugwaro uye rusina masero, ose ayo asina hanya nebasa racho.

Zvadaro, nhamba dzichawedzerwa kune masero ayo asina ganda rekare kana rine mavara. Zvose zvezera racho zvichange zvichinyatsogadziriswa kusanganisira data itsva.

Kupinda Tutorial Data

1. Isa data inotevera iri mumasero A1 kusvika kuA6 : 114, 165, 178, zvinyorwa.
2. Siya sero A5 isina chinhu.
3. Isa zvinotevera data muchikamu che66 : 165.

Kupinda Basa reSUM

1. Dzvanya pane sero A7 , nzvimbo iyo migumisiro yebasa reSUM icharatidzwa.
2. Dzvanya kuIta > Imabasa > SUM mumamenu kuti uise basa reSUM muchikamu cheA7 .
3. Simbisai ma cell A1 neA6 kuti muve nehuwandu hwemashoko sehutano hwebasa.
4. Dhinda pikicha inopinda mubhokisi.
5. Nhamba 622 inofanira kuonekwa muchitokisi A7, iyo ndiyo yekuti nhamba yacho inopinda mumasero A1 kusvika kuA6.

Kudzokorora basa reSUM

1. Tora iyo nhamba 200 muchikamu cheA5 uye pinda paImpikisi pane keyboard.
2. Mhinduro 622 muchikamu cheA7 inofanira kudzokera ku 822.
3. Dzokorora zvinyorwa zvinyorwa muchitokisi A4 ine nhamba 100 uye diya muIndo yeUngi pane keyboard.
4. Mhinduro yacho muna A7 inofanira kudzokera kune 922.
5. Dzvanya pane sero A7 uye zvakakwana basa = SUM (A1: A6) inowanikwa mubhairi yepamusoro pane pepa pepaji