Mienzaniso ye "Smerei" basa muExcel

Syntax uye Sisitasiti Chisiko

Basa racho rinonyanya kufarirwa, nekuti munenge patafura yega yega, zvakakosha kuti uverenge huwandu hwehuwandu mumasero, uchifuratira tsika dzisingawiri pasi pemamiriro makuru. Kutenda kune iyi formula, kuverenga hakunde uye kwenguva refu. Iyo Standard Dhizaini Yekuita Inoita se = Nyarara (Range, Range - Range_Summing), uye "Summation Range" inoratidzwa chete pasi pemasero mamiriro ezvinhu apo kune iwo masero chaiwo, anoitwa anoitwa pasi pemamiriro ezvinhu chero api. Kana iyo data mu "kuwanda" isipo, masero ese anosanganisirwa mu "huwandu" huchaongororwa.

Tichaongorora nharo mbiri dzasara - "huwandu" uye "chinongedzo". Kukodzera kwekutanga kwemasero (A1: A100) Inokodzera (A1: A100), iyo ichaongororwa uye ichienzaniswa nemamiriro acho. Mu "chinongedzo", mushandisi anounza mamiriro ezvinhu, kana achiita sero racho rikava rimwe remazwi. Izvi zvinogona kuve mamiriro ekusaenzana kwehuwandu (50) kana kutevedzera neiyo yakataurwa zvinyorwa ("zvinyorwa"). Kuti urarame nzwisiso yekuisirwa kwekupokana, vhura iyo mifananidzo yemifananidzo "yekupokana" uye yakaisa mamiriro ese ezvinhu zvakare mukusiyana muminda yakasiyana.

Iko hakuna akawanda mienzaniso mimwe mimwe dzakasiyana, izvo zvinozadzika zvazvinazvo zvakakodzera kuongorora kana basa racho rakanyarara, uye robva ravhenekera zvakakanganisika uye zvakakurumbira.

Basa racho rakanyarara pasi pemamiriro ekusaenzana

Muenzaniso wekutanga ndewekushandiswa kwebasa rebasa racho, chero kuti nhamba yeiyo hit inofanira kunge yakakura, zvishoma kana isina kuenzana nenhamba yakatarwa. Nesyiyo yakadaro syntax, basa rinotarisa masero ese eiyo yakatarwa renji uye anofunga akakodzera chete. Manual kunyora iyo kuburikidza neyakaisa munda ine zvikamu zvakati:

1. Sarudza mhando yemasero inowira for formula, tichava nemubairo wemwedzi.



2. Kutanga kupinda kubva mumirayiridzo yayo mundima yekuisa nekuzvinyora ivo pachavo.



3. Gadzira bracket uye kuvhara bracket paunopinda mumhando yakasarudzwa masero, semuenzaniso C2: C25. Mushure meizvozvo, ita chokwadi chekusaina; zvinoreva kuti kuguma kwekupokana.



4. Vhura Quotes uye taura mamiriro ezvinhu ayo mune yedu kesi ichave> 300000.



5. Pangosvika pakudzvanya iyo ENTER kiyi, basa racho rakamiswa. Mune skrini, zviri pachena kuti masero maviri chete anoenderana nechimiro> 300000, saka, fomula inopfupisa nhamba yavo uye inoratidza muchivharo.

Pamusoro, imwe chete yemienzaniso yakatorwa netsaona yakatorwa mamiriro akasanganiswa. Hapana chichadzivirira chero chinhu chekutsiva mamwe mimwe tsika, wedzera kana kudzikisira huwandu - iyo formula ichiri kungofunga kukosha kana mutemo weSynax zvakacherechedzwa.

Basa racho rakanyarara, pasi pekufananidza zvinyorwa

Tora muenzaniso wechipiri kana ivo vakanyarara vaigara vachiverenga huwandu mumasero anoiswa pasi pekutevedzera nezvakanyorwa mune mamwe maruva emabhuruku. Izvi zvichabatsira, semuenzaniso, apo mutengo wakazara wezvinhu zvese mune imwe chikamu chakaverengerwa, kana mutengo wekambani wemari kune vashandi vanoverengerwa pazvinhu zvakananga. Muenzaniso wekunyoreswa mumamiriro ezvinhu aya achiri kunakidzwa nenyaya yekuti syntax inoshanduka zvishoma, sezvo mamiriro acho anowira pasi pechipiri masero.

1. Ino nguva, mukuwedzera kune huwandu hwemasero anopfupikiswa, sarudza izvo zvinowanikwa zvakanyorwa mumamiriro ezvinhu.



2. Tanga kurekodha basa kubva mukusarudzwa kwayo nenzira imwecheteyo sezvazvinoratidzwa pamusoro apa.



3. Kutanga, pinda muropa nezvakanyorwa, chiiswa; Uye isa mamiriro. Ipapo uku kutaura mune syntactic fomati ichawana imwe mhando: A2: A25; "Gunyana";



4. Sezvo nharo yekupedzisira, inosara yekufungidzira huwandu hwemasero, huwandu hweripi huchapfupikiswa pamamiriro ekurudyi. Iwe watoziva nemirairo yekurekodha kupokana kwakadaro.



5. Tarisa uone chiitiko chekuita. Isu tinosanangura mwedzi waSeptember semamiriro ezvinhu uye tarisa patafura, iyo yakapfupikisa maitiro maviri emasero tafura anoenderana nezvayo. Iyo yasara data kana uchitarisa ichangobva kufuratirwa.

Tsiva izwi kana isa mutsara wose, wakapihwa iyo chiratidzo chinonyoreswa kuti ugadzire ivo pachavo kana uchiverenga tsika dzinodiwa.

Shanda SmErevilm nemamiriro akati wandei

Takapedza kuongororwa kwemienzaniso neyechitatu sarudzo, kana mamiriro ezvinhu ekuwedzera akati wandei kamwechete. Nekuverenga kwakadaro, basa riri pasi pekutarisa rinotsiviwa neiyo yakagadziridzwa svmemalimn, inobvumira kuti uise kupokana kunopfuura kamwe, iyo isingakwanise kuitwa mune yekutanga vhezheni. Imwe yemienzaniso yakapfava ine yakazara syntactic tsamba yakagadzirwa seinotevera:

1. Tora tafura iyo kune matatu akasiyana maitiro ese pane iyo data ipapo uye zvinoenderana nemhando yavo. Uyu mwedzi, iyo purofiti uye huwandu hwezvinhu zvinotengeswa. Mune formula nemamiriro akati wandei, zvakakosha kuti uite chete izvo zvinobatsira, izvo zvakawanikwa munaSeptember zvichitengesa pamusoro pemakumi matatu nemakumi matatu.



2. Tanga kupinda kubva kuiyo shambadziro yeiyo = smErullime, vhura mabhureki uye nyora kuti ndeipi mhando yemasero inopfupikiswa. Usakanganwa kuvhara chiziviso cheChiratidzo Chekupokana;



3. Kutevera kukakavara kwechipiri - kuwirirana nezita muchitokisi. Kurekodha kweiyi paramende yaive yatofungidzirwa pamusoro uye inogona kuonekwa zvakare mu skrini.



4. Chimiro chechitatu ndiyo tsamba yekusagadzikana kwayo, iyo isu takazviziva pakutanga kwechinyorwa ichi. Zvakare nenzira imwecheteyo, taura huwandu hwehunhu uye kusaenzana pachako mumashoko. Usakanganwa kuisa iyo yekuvhara bracket, nekudaro kupedzisa basa rekunyora.



5. Zvizere, mutsara webasa iri une fomu = svumpremullime (C2: C25: A2: ACTELO: "Gunyana"; "b2: Zvinogona kuita sekuti zvakaoma kuzivisa kupokana rega rega uye kusavhiringidzika muvanhurume, asi nepakati pepakati panofanirwa kunge pasina matambudziko.

Vanogomera zvakare uye svumpremull ndezvemabasa emasvomhu vane chinomiririra zvakafanana, asi zvinoshandiswa mumamiriro ezvinhu akasiyana. Kuti uverenge ruzivo pane ese mafomu akakurumbira muExcel, anoreva zvinhu zvinorehwa pazasi.

Verenga Zvakawanda: 10 Yakakurumbira masvomhu mabasa Microsoft Excern Excel