Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row

Kushanda neruzivo rwetabular, vashandisi vanowanzoda kuverenga huwandu hwechiratidzo. Kazhinji zviratidzo izvi ndiwo mazita emitsara iyo inofanirwa kupfupisa ruzivo rwese mumasero. Kubva kuchinyorwa iwe uchadzidza nzira dzese dzinokutendera kuti uite maitiro aya.

Sum values ​​mumutsara

Iwe unogona kuburitsa maitiro ekupfupisa tsika mumutsara uchishandisa dzinotevera nzira:

  • arithmetic formula;
  • auto summation;
  • mabasa akasiyana-siyana.

Imwe neimwe yeiyi nzira yakakamurwa kuita dzimwe nzira. Ngatibatane navo zvakadzama.

Nzira 1: arithmetic formula

Kutanga, ngationei kuti sei, tichishandisa arithmetic formula, zvinokwanisika kupfupisa mumutsara. Ngationgororei zvese nemuenzaniso chaiwo. Ngatitii tine tafura inoratidza mari yezvitoro zvishanu pane mamwe mazuva. Mazita ezvitoro ndiwo mazita emitsara. Mazuva ndiwo mazita emakoramu.

Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
1

Chinangwa: kuverenga huwandu hwemari yekuwana yekutanga yenguva yese. Kuti uwane chinangwa ichi, zvakakosha kuwedzera masero ose emutsara ane chokuita nechitoro ichi. Iyo yekufamba inotaridzika seiyi:

  1. Isu tinosarudza sero apo mhedzisiro icharatidzwa mune ramangwana. Isa chiratidzo "=" muchitokisi. Isu tinodzvanya LMB pasero rekutanga mumutsara uyu une zviratidzi zvenhamba. Isu tinoona kuti mushure mekudzvanya maseru macoordinate akaratidzwa muchitokisi kuti averenge mhedzisiro. Isa chiratidzo "+" uye tinya pane inotevera sero mumutsara. Isu tinoenderera mberi nekuchinjanisa chiratidzo "+" nemarongedzero emaseru emutsara wekutanga kubuda. Nekuda kweizvozvo, tinowana formula: =B3+C3+D3+E3+F3+G3+H3.
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
2
  1. Mushure mekuita zvese manipulations, tinya "Enter".
  2. Ready! Mhedzisiro yacho yakaratidzwa muchitokisi umo takaisa fomula yekuverengera huwandu.
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
3

Teerera! Sezvauri kuona, iyi nzira yakajeka uye iri nyore, asi ine imwe yakashata drawback. Kuitwa kweiyi nzira kunotora nguva yakawanda. Ngatitarisei kukurumidza kusiyanisa kwekupfupisa.

Nzira 2: AutoSum

Kushandisa autosum inzira inokurumidza kupfuura yakurukurwa pamusoro. Iyo yekufamba inotaridzika seiyi:

  1. Tichishandisa LMB yakadzvanywa, tinosarudza ese maseru emutsara wekutanga ane data yenhamba. Isu tinotamira kune "Kumba" chikamu, chiri pamusoro peiyo spreadsheet interface. Isu tinowana block yemirairo "Editing" uye tinya pane chinhu chinonzi "Editing".
    Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
    4

Kurudziro! Imwe sarudzo ndeye kuenda kuchikamu che "Formulas" uye tinya bhatani re "AutoSum" riri mu "Function Library" block. Yechitatu sarudzo ndeye kushandisa kiyi yekubatanidza "Alt" + "="" mushure mekusarudza sero.

Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
5
  1. Zvisinei nesarudzo ipi yawaisa, kukosha kwenhamba kwakaonekwa kurudyi kwemasero akasarudzwa. Nhamba iyi ndiyo uwandu hwezvibodzwa zvemitsetse.
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
6

Sezvauri kuona, iyi nzira inoita pfupiso mumutsara nekukurumidza kupfuura iri pamusoro. Mhedzisiro huru ndeyokuti chigumisiro chinoratidzwa chete kurudyi rwemhando yakasarudzwa. Kuti chigumisiro chionekwe mune chero nzvimbo yakasarudzwa, zvakakosha kushandisa dzimwe nzira.

Nzira 3: SUM basa

Kushandisa iyo yakabatanidzwa spreadsheet function inonzi SUM haina zvipingamupinyi zvemitoo yakambokurukurwa. SUM ibasa remasvomhu. Basa remushandisi ndeyekupfupisa kwenhamba dzenhamba. Maonero ese emushandisi: =SUM(nhamba1,nhamba2,…).

Zvinokosha! Nharo dzebasa iri dzinogona kuve nhamba dzenhamba kana maseru coordinates. Nhamba yepamusoro yenharo ndeye 255.

Nhanho-ne-nhanho tutori inoita seizvi:

  1. Isu tinosarudza chero sero isina chinhu pane pepa rekushanda. Mariri ticharatidza mhedzisiro yesummary. Zvakakosha kucherechedza kuti inogona kunge iri pane imwe pepa rekushanda regwaro. Mushure mekuita sarudzo, tinya bhatani re "Insert Function", riri pedyo nemutsara wekupinda mafomula.
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
7
  1. Iwindo diki rainzi "Function Wizard" rairatidzwa pachiratidziri. Wedzera rondedzero padivi pechinyorwa "Chikamu:" uye sarudza chinhu "Mathematical". Pazasi padiki pane rondedzero "Sarudza basa:" tinowana iyo SUM opareta uye tinya pairi. Mushure mekuita zvese manipulations, tinya bhatani rekuti "OK" riri pazasi pehwindo.
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
8
  1. Hwindo rakanzi "Function Arguments" rakabuda pachiratidziro. Mundima isina chinhu "Nhamba1" isa kero yemutsara, kukosha kwaunoda kuwedzera. Kuti tiite iyi nzira, tinoisa chinongedzo mumutsara uyu, uyezve, tichishandisa LMB, tinosarudza chiyero chose nenhamba dzenhamba. Mushure mekuita zvese manipulations, tinya pakanzi "OK".
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
9
  1. Ready! Mhedzisiro yekupfupisa yakaratidzwa mune yekutanga yakasarudzwa sero.
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
10

SUM basa harisi kushanda

Dzimwe nguva zvinoitika kuti SUM opareta haashande. Zvikonzero zvikuru zvekutadza kushanda zvakanaka:

  • nhamba isiriyo fomati (chinyorwa) paunenge uchipinza data;
  • kuvapo kwemavara akavanzika uye nzvimbo mumasero ane nhamba dzenhamba.

Izvo zvakakosha kuti uzive! Nhamba dzenhamba dzinogara dzakaruramiswa uye ruzivo rwemavara runogara rwakasiiwa-chakaruramiswa.

Nzira yekuwana sei huwandu hwehukuru (hudiki) hwakakosha

Ngationei kuti tingaverenge sei huwandu hwezvidiki kana zvakakura zvakakosha. Semuenzaniso, isu tinofanirwa kupfupisa matatu mashoma kana matatu epamusoro kukosha.

Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
11

Iyo GREATEST opareta inobvumidza iwe kudzosa iyo yakanyanya mamaki kubva kune yakasarudzwa data. Nharo yechipiri inotsanangura kuti ndeipi metric yekudzosa. Mumuenzaniso wedu chaiwo, fomula inotaridzika seizvi: =СУММ(НАИБОЛЬШИЙ(B2:D13;{1;2;3})).

Kutsvaga kweiyo diki kukosha kunoshanda nenzira imwechete, chete iyo SMALL basa rinoshandiswa pachinzvimbo cheGREATEST opareta. Iyo formula inoita seizvi: =СУММ(НАИМЕНЬШИЙ(B2:D13;{1;2;3})).

Kutambanudzira muchidimbu formula/basa kune mamwe mitsara

Takaona kuti huwandu hwese hunoverengerwa sei maseru mumutsara mumwe. Ngationei maitiro ekuita maitirwo ekuita muchidimbu pamusoro pemitsara yese yetafura. Kunyora mafomula nemaoko uye kuisa mushandisi weSUM inzira refu uye dzisingashande. Iyo yakakwana mhinduro ndeyekutambanudza basa kana fomula kune inodiwa nhamba yemitsara. Iyo yekufamba inotaridzika seiyi:

  1. Isu tinoverenga mari yacho tichishandisa imwe yenzira dziri pamusoro apa. Fambisa chinongedzo chembeva kuzasi chekurudyi furemu yesero nemhedzisiro yaratidzwa. Iyo cursor inotora chimiro chediki dema plus chiratidzo. Bata LMB uye dhonza formula kusvika pazasi peplate.
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
12
  1. Ready! Takapfupisa mibairo yemazita ese. Isu takawana mhedzisiro iyi nekuda kwekuti kana uchikopa fomula, kero dzinochinja. Kugadziriswa kwemakodha kunokonzerwa nekuti kero dzine hukama.
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
13
  1. Pamutsetse wechitatu, fomula yacho inoita senge: =B3+C3+D3+E3+F3+G3+H3.
Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
14

Maverengero ehuwandu hwemutsara wega wega Nth.

Pamuenzaniso chaiwo, tichaongorora maverengero ehuwandu hwemutsara wega wega weNth. Semuenzaniso, isu tine tafura inoratidza purofiti yemazuva ese yekubuda kweimwe nguva yenguva.

Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
15

Basa: kuverenga purofiti yevhiki nevhiki yevhiki yega yega. Iyo SUM opareta inobvumidza iwe kuunganidza data kwete chete muhuwandu, asiwo muhurongwa. Pano zvakakosha kushandisa mubatsiri opareta OFFSET. Iyo OFFSET opareta inotsanangura akati wandei enharo:

  1. Pfungwa yekutanga. Sero C2 inopinzwa sereferensi yakakwana.
  2. Nhamba yematanho pasi.
  3. Nhamba yematanho kurudyi.
  4. Nhamba yematanho pasi.
  5. Huwandu hwemakoramu muhurongwa. Kurova poindi yekupedzisira yemhando yezviratidzo.

Isu tinopedzisa neinotevera formula yevhiki yekutanga: =СУММ(СМЕЩ($C$2;(СТРОКА()-2)*5;0;5;1)). Nekuda kweizvozvo, iyo sum operator inokwana ese mashanu manhamba kukosha.

3-D sum, kana kushanda nemapepa akawanda eExcel workbook

Kuti uverenge manhamba kubva pachimiro chakafanana pahuwandu hwemashizha ebasa, sintakisi yakakosha inonzi "3D referensi" inofanirwa kushandiswa. Ngatitii pamapepa ebasa ose ebhuku pane ndiro ine mashoko evhiki. Tinofanira kuisa zvose pamwe chete uye tiuye nayo kune nhamba yemwedzi. Kuti utange, unofanirwa kuona vhidhiyo inotevera:

Tine mahwendefa mana akafanana. Iyo yakajairika nzira yekuverenga purofiti inoita seizvi: =СУММ(неделя1!B2:B8;неделя2!B2:B8;неделя3!B2:B8;неделя4!B2:B8). Pano, mitsara yemasero inoita senharo.

Iyo 3D sum formula inoita seizvi: =SUM(vhiki1:vhiki4!B2:B8). Inotaura pano kuti kupfupisa kunoitwa mumarenji B2:B8, ari pamapepa ebasa: vhiki (kubva pa1 kusvika 4). Pane nhanho-ne-nhanho kuwedzera kwenhamba yepepa rekushanda nerimwe.

Pfupi nemamiriro akawanda

Pane dzimwe nguva apo mushandisi anoda kugadzirisa dambudziko rinotsanangura maviri kana anopfuura mamiriro uye inoda kuverenga huwandu hwehuwandu hwehuwandu zvinoenderana nemaitiro akasiyana. Kuti uite iyi nzira, shandisa basa «=SUMMESLIMN".

Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
16

Nhanho-ne-nhanho tutori inoita seizvi:

  1. Kutanga, tafura inoumbwa.
  2. Inosarudza sero umo mhedzisiro icharatidzwa.
  3. Enda kumutsara wekuisa mafomula.
  4. Isu tinopinda mushandisi: =SUMMAESLIMN.
  5. Nhanho nhanho, tinopinda muhuwandu hwekuwedzera, huwandu hwemamiriro ezvinhu1, condition1 nezvimwe zvakadaro.
  6. Mushure mekuita zvese manipulations, tinya "Enter". Ready! Kuverenga kwaitwa.

Zvakakosha kucherechedza! Panofanira kunge paine chinoparadzanisa muchimiro chesemicolon ";" pakati penharo dzemushandisi. Kana iyi delimiter ikasashandiswa, iyo spreadsheet ichaita chikanganiso chinoratidza kuti basa rakaiswa zvisizvo.

Maverengero ehuwandu hwehuwandu

Iye zvino ngatitaurei nezve nzira yekunyatsoverenga chikamu chemari. Nzira iri nyore, iyo ichanzwisiswa nevashandisi vese, ndeyekushandisa chikamu kana mutemo we "square". Essence inogona kunzwisiswa kubva pamufananidzo uri pazasi:

Maitiro ekuverenga huwandu mumutsara muExcel. 3 Nzira dzeKuverengera Huwandu hweNhamba muExcel Row
17

Mari yose inoratidzwa muchitokisi F8 uye ine kukosha kwe 3060. Mune mamwe mazwi, iyi ndiyo zana kubva muzana mari, uye tinoda kuwana kuti yakawanda sei purofiti yakaitwa naSasha. Kuti tiverenge, tinoshandisa yakakosha chikamu formula, inoita seizvi: =F10*G8/F8.

Zvinokosha! Chekutanga pane zvese, mbiri dzinozivikanwa manhamba u2bu3bare yakawedzera diagonally, ndokuzopatsanurwa neyasara yechishanu kukosha.

Uchishandisa mutemo uyu uri nyore, unogona nyore uye nyore kuverenga chikamu chehuwandu.

mhedziso

Chinyorwa chakakurukura nzira dzinoverengeka dzekuwana huwandu hwe data mumutsara muExcel spreadsheet. Imwe neimwe nzira ine zvayakanakira nezvayakaipira. Kushandisa fomula yemasvomhu ndiyo nzira iri nyore kushandisa, asi yakakodzera kuishandisa paunenge uchishanda neruzivo rudiki. Nekushanda nehuwandu hwe data, otomatiki muchidimbu inonyatso inokodzera, pamwe neiyo SUM basa.

Leave a Reply