01 ye 02
OpenOffice Calc SUM Basa
Kuwedzera mitsetse kana nhamba dze nhamba ndeimwe yemabasa anowanzoshandiswa mumapurogiramu epadheseti seOverOffice Calc. Kuita kuti zvive nyore kuita basa iri, Calc inosanganisira yakavakwa mumushonga unonzi SUM basa .
Nzira mbiri dzekupinda mubasa iri dzinosanganisira:
- Uchishandisa bhodhi reSUM rutsutsinho rwebasa - ndiyo yechiGiriki tsamba huru Sigma (Σ) iri pedyo nemugero wekutsvaga (yakafanana neyomurairi yemuenzaniso muExcel).
- Kuwedzera basa reSUM pane pepa rekushandisa uchishandisa basa wizard dialog box. Bhokisi rebhokisi rinogona kuvhurwa kuburikidza nebhokisi reKumushandira Wizard iri pedyo neBigma bhokisi pamutsara wokupinda .
Shortcut nebhokisi reDialog Mabhadharo
Kubudirira kwekushandisa bhizinesi re Sigma kupinda mubasa ndechokuti yakakurumidza uye iri nyore kushandisa. Kana iyo data inopfupikiswa yakabatana pamwe chete muzera rakanyanyisa basa rinowanzosarudza mararamiro ako.
Kubudirira kwekushandisa SUM basa basa bhokisi rebhokisi nderokuti data inopfupiswa inopararira pamusoro pemamwe masero asina kukodzera. Kushandisa bhokisi rebhokisi mumamiriro ezvinhu rinoita kuti zvive nyore kuwedzera masero ari oga kumabasa.
Syntax SUM Function uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara webasa reSUM ndewokuti:
= SUM (nhamba 1; nhamba 2; ... nhamba 30)
nhamba 1; nhamba 2; ... nhamba 30 - iyo data inopfupiswa nemabasa. Nharo dzinogona kuva:
- runyorwa rwemashamba kuti runopfupiswa
- runyora rwemasero zvinyorwa zvinoratidza nzvimbo ye data mune pepa rekushanda
- ruzivo rwemaferensi rinorondedzerwa kunzvimbo yedata
Cherechedza : iyo yakawanda yenhamba makumi matatu inogona kuwedzerwa nemabasa.
Icho Basa reSUM Rinorambidza
Basa racho rinoshora pasina masero uye kunyora deta mumusarudzo yakasarudzwa - kusanganisira nhamba dzave dzichishandurwa semashoko.
Nekutadza, mavara epaCalc akasiyiwa akashandurwa mumusero - sekuonekwa pamwe nenhamba 160 muchitokisi A2 mumufananidzo wepamusoro - dhamba re data rinowirirana kurudyi nekusingaperi.
Kana zvakadaro dhesi rekufambisa ichishandurwa kuverenga nhamba kana nhamba inowanikwa kune dzisina kubatsira masero muhuwandu, basa reSUM rinoshandiswa zvese rinoshandiswa kuisa data itsva.
Kushandisa Manuyo Basa reSUM
Asi imwe nzira yekupinda mubasa iri kuinyora iyo musepa rekushanda. Kana zvinyorwa zvemasero zvehuwandu hwemashoko zvakadhindwa zvinozivikanwa, basa rinogona kuiswa nyore nyore. Nokuda kwemuenzaniso mumufananidzo uri pamusoro, kuverenga
= SUM (A1: A6)
muchitokisi A7 uye kuvhara muIno yeKisi paikiriti yaizobudirira mugumisiro mumwechete seye matanho akarongerwa pasi apa kushandisa SUM mukana wekutsinhanisa.
Summing Data neSUM Button
Kune avo vanosarudza hove kune keyboard, SUM bhatani inzira inokurumidza uye iri nyore kupinda muSUM basa.
Kana wapinda nenzira iyi, basa rinoedza kutarisa mararamiro emasero kuti adimbudzikwe kubva pane dheta rakapoteredza uye anongopinda maitiro akawandisa semafungiro ehamba nenyaya.
Basa chete rinotsvaga nhamba yedata iri mumakoromeri ari kumusoro kana mumitsara kuruboshwe rwebasa rinoshanda uye rinorega kunyora mashoko uye pasina masero.
Pasi panonyorwa matanho anoshandiswa kupinda muSUM basa mumusero A7 sezvakaratidzwa mumufananidzo uri pamusoro.
- Dzvanya pachitokisi A7 kuti uite sero rinoshanda - nzvimbo iyo migumisiro yebasa icharatidzwa
- Dhinda pfupa reSUM riri pedyo nemutsara wokupinza - sezvakaratidzwa mumufananidzo uri pamusoro
- Basa reSUM rinofanira kunge rakapinda mumusero unoshanda - basa racho rinofanira kungoerekana raisa sero renhoroondo A6 senhamba yenyaya
- Kuti uchinje uwandu hwemasero ezvinyorwa zvinoshandiswa munyaya yenyaya, shandisa mutsara wepiguru kuti uise pachena rutivi rweA1 kusvika kuA6
- Dhinda pikicha inopinda mubhokisi kuti upedze basa
- Mhinduro 417 inofanira kuiswa muchitokisi A7
- Paunenge uchinyora pachitsauko A7, basa rakakwana = SUM (A1: A6) rinowanikwa mumutsara wekushandisa uri pamusoro pehwhepa.
02 of 02
Wedzera Nhamba Kushandisa Calc's SUM Function Dialog Box
Summing Data neBUS Function Dialog Box
Sezvakataurwa, imwe sarudzo yekupinda muSUM basa ndeyokushandisa bhokisi rebasa rebasa, iro rinogona kuvhurwa kana:
- nokudhinda bhokisi reSection Wizard pamuganhu wokupinza uri pamusoro pehwhepa.
- kumanikidza Ctrl + F2 makii pane keyboard
Bhokisi reDhiyabhorosi Mazano
Makomborero ekushandisa bhajiro rebhokisi inosanganisira:
- Iyo bhokisi rinotarisa kushandiswa kweshoko rekushanda - zvichiita kuti zvive nyore kupinda mhinduro dzebasa rimwe chete pane imwe nguva pasina kuisa chiratidzo chakaenzana, mabheji, kana semicolons inoshanda sevanoparadzanisa pakati penharo.
- Apo dheta rinopfupikiswa haisi mumuganhu wakazara, zvinyorwa zvese, zvakadai seA1, A3, uye B2: B3 zvinogona kuiswa nyore nyore sezvikamu zvakasiyana zvemibvunzo mubhokisi rebhokisi uchitsanangura -zvinosanganisira kusarudza masero akasarudzwa ne pfupa pane kuvaisa mukati. Haisi kungoerekana ichitaura nyore, inobatsirawo kuderedza mapurogiramu mumafomu anokonzerwa nemaitiro asina kukodzera masero.
SUM Function Muenzaniso
Pasi panonyorwa matanho anoshandiswa kupinda muSUM basa mumusero A7 sezvakaratidzwa mumufananidzo uri pamusoro. Iyo mirayiridzo inoshandisa SUM basa bhokisi rebhokisi kuti uise maitiro ari mumasero A1, A3, A6, B2, uye B3 senhamba dzenhamba dzebasa racho.
- Dzvanya pachitokisi A7 kuti uite sero rinoshanda - nzvimbo iyo migumisiro yebasa icharatidzwa
- Dzvanya paMushandi Wemagetsi wechiratidzo pedyo nemutsara wokupinza (wakafanana nebar bar in Excel) kuti uuye neBusiness Workflow box box
- Dzvanya muDhesi ye-drop-down list uye sarudza Mathematical kuona urongwa hwemasvomhu inoshanda
- Sarudza SUM kubva pane zvakarongwa zvemabasa
- Dhinda Kutevera
- Dzvanya pa nhamba 1 mubhokisi rebhokisi kana zvichidiwa
- Dzvanya pane sero A1 mune pepa rekushandisa kuti uise iyo seferensi iri mubhokisi rebhokisi
- Dzvanya pane nhamba 2 mubhokisi rebhokisi
- Dzvanya pane sero A3 mune pepa rekushandisa kuti uise iyo cell reference
- Dzvanya pane nhamba 3 mubhokisi rebhokisi
- Dzvanya pane sero A6 mune pepa rekushandisa kuti uise iyo cell reference
- Dzvanya pane nhamba 4 mubhokisi rebhokisi
- Simbisai masero B2: B3 mune pepa rekushandisa kuti uise muzera iri
- Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda
- Nhamba 695 inofanira kuonekwa muchikamu cheA7 - sezvo ichi ndicho chiverengero chemanani ari mumasero A1 kusvika kuB3
- Paunenge uchinyora pavha A7 basa rakakwana = SUM (A1; A3; A6; B2: B3) inowanikwa mumutsara wokupinza uri pamusoro pebasa