Kurumidza Sum Sum Columns kana Row of Numeri mu Excel

Wedzera zvinhu zvakasimba

Kuwedzera mapuranga kana mitsara ye nhamba ndeimwe yezviito zvinowanzoitwa pane mapurogiramu espredishiti seExcel kana Google Spreadsheets .

Basa reSUM rinopa nzira yakakurumidza uye iri nyore yekuita basa iri muExpcel worksheet.

01 ye 05

Iyo SUM Function Syntax uye Arguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Mutsara webasa reSUM ndewokuti:

= SUM (Nhamba1, Nhamba2, ... Nhamba255)

Nhamba1 - (inoda) kukosha kwekutanga kunopfupiswa.
Iyi nharo inogona kuva nemashoko chaiwo ari kupfupiswa kana inogona kuva sero rinotarisa kune nzvimbo yedhidhi mune pepaji .

Nhamba2, Nhamba3, ... Nhamba255 - (zvichida) mamwe maitiro anokwaniswa kudimburwa kusvika pa 255.

02 of 05

Kupinda Basa reSUM Kushandisa zvidzitiro

Zvakakurumbira ndeye basa reSUM kuti Microsoft yakagadzira zvidzitiro zviviri kuti zvive nyore nyore kushandisa:

• The shortcut keyboard.
• AutoSUM paImba yebhubhoni.

Zvimwe zvingasarudzwa zvekupinda mubasa zvinosanganisira:

• Achishandisa bhokisi rebasa rebasa.
• Kupinda basa racho nemaune.

03 of 05

Sum Data mu Excel Kushandisa Shortcut Keys

Iko mubatanidzwa wekutanga wekupinza basa reSUM nderekuti:

Alt + = (chiratidzo chakaenzana)

Muenzaniso

Matanho anotevera anoshandiswa kupinda muSUM basa kuburikidza nemakona ekutsvaga pamusoro apa

1. Dzvanya pane sero apo basa reSUM rinofanira kuwanikwa.
2. Dhinda uye ubatisise Key Alt pane keyboard.
3. Dhinda uye usunungure chiratidzo chakaenzana (=) pane keyboard asi usunungurire Alt key.
4. Bvisa Alt key.
5. Basa reSUM rinofanira kunge rakapinda musero rinoshanda rine Insertion point kana tsanangu iri pakati peviri yevasina mabhoti asina chinhu.
6. Mabhokete anobata nharo yebasa - rutivi rwemaferensi ezvitera kana nhamba kuti dzinopfupiswa.
7. Pinda nharo yebasa:
   • uchishandisa pfungwa uye chengeta ne mouse kuti uise mumwe munhu masero zvinyorwa (ona Cherechedza pasi);
   • uchishandisa hovha uye dhonza ne mouse kuti uise ruzivo rwakasiyana rwemasero;
   • kuisa mumatare kana kuti magetsi zvinyorwa.
8. Kana imwe nguva mhirizhonga ichipindwa, pinda paIngiyi pane kibhokisi kuti upedze basa;
9. Mhinduro yacho inofanira kuonekwa muchitokisi ine basa;
10. Paunenge uchitsvaga pane sero rine mhinduro, basa rakapedzerwa SUM rinowanikwa mubhairi yepamusoro pane pepa pepaji;

Cherechedza : Paunopinda nharo yebasa, yeuka:

• mumwe munhu masero anonyorwa akaiswa nekunyora kana kutanidza anofanira kuparadzaniswa nemakasa;
• nokuda kwemazana ezvinyorwa zvinyorwa zvakatonyorwa nekunyora, kutanga uye kuguma kumwe zvikamu zvinyorwa zvinogona kuparadzaniswa nekoloni yakazara (:)

04 of 05

Sum Data mu Excel Kushandisa AutoSUM

Kune avo vanosarudza kushandisa mouse panzvimbo yebhokisi, tsvina yeA AutoSUM iri paKumusoro kwebhubhoni yebhoni, sezvinoratidzwa mumufananidzo uri pamusoro, inogona kushandiswa kupinda muSUM basa.

Chikamu Chokutengesa kwezita rinonzi AutoSUM chinoreva kuti kana wapinda uchishandisa nzira iyi, basa rinosarudza zvarinotenda kuti mararamiro emasero anotsanangurwa nebasa racho.

Sezvinoratidzwa mumufananidzo uri pamusoro, sarudzo yakasarudzwa yakasvibiswa uye yakakomberedzwa nemuganhu unofanirwa unozivikanwa sekumhanya masvosve.

Cherechedza :

• Basa reSUM rakagadzirirwa kuiswa pasi pekorodhe ye data kana kumucheto wakarurama wemutsara we data.
• Kana basa reSUM rapinda pane imwe nzvimbo kunze kweiyi, huwandu hwemasero akasarudzwa sehutano hwebasa hungave husina kunaka.
• Kuti uchinje mararamiro akasarudzwa, shandisa mouse pointer kuti uise pachena mabheji akakodzera usati wanyora muItena kuti upedze basa

Kushandisa AutoSUM:

1. Dzvanya pane sero iyo basa rinofanira kuwanikwa;
2. Dhinda mufananidzo we AutoSUM pane ribhoni;
3. Basa reSUM rinofanira kunge rakapinda musero rinoshandiswa nehuwandu hwehutano hunopfupiswa;
4. Tarisa kuti uone kuti rutivi rwakakomberedzwa - runoita hurumende yebasa yakarurama;
5. Kana iyo yakatarisa yakarurama, pinda paIngiyi pakiti pane keyboard kuti upedze basa;
6. Mhinduro yacho icharatidzwa muchitokisi iyo basa rakapinda;
7. Paunenge uchitsvaga pane sero rine mhinduro, basa rakapedzwa SUM rinowanikwa mubhairi yepamusoro pane pepa pepaji.

05 of 05

Kushandisa SUM Function Dialog Box

Zvose zvinoshanda muExcel zvinogona kuiswa vachishandisa bhokisi rebhokisi , rinokubvumira kupinda maonero ebasa pamiganhu yakasiyana. Irobhokisi rinotarisawo sangano rebasa - sevabereki vekuzarura nekuvhara uye mavhavha anoshandiswa kuparadzanisa nharo dzemunhu mumwe nomumwe.

Kunyange zvazvo nhamba dzomunhu dzichigona kupinda zvakananga mubhokisi rebhokisi semafungiro, zvinowanzonyanya kuisa deta mumashandi ekushanda mapepa uye kuisa sero zvinyorwa sezvikonzero zvebasa racho.

Kuisa basa reSUM uchishandisa bhokisi rebhokisi:

1. Dzvanya pane sero iyo migumisiro icharatidzwa.
2. Dzvanya paMafomu yebhu yebhoni yebhoni .
3. Sarudza Math & Trig kubva kubhoni kuti uzarure basa rakaderera pasi.
4. Dzvanya paSUM mune urongwa kuti ubudise bhokisi rebasa rebasa;
5. Mubhokisi rebhokisi, tora paNhamba1 .
6. Ita kuti zvinyorwa zvinyorwa zvioneke kana kuti zvinyorwa zvakasiyana.
7. Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi.
8. Mhinduro yacho inofanira kuonekwa museri yakasarudzwa.