Indlela Yokuhlanganisa Amakholomu noma Imigqa kumaSpredishithi e-Google

Ukusetshenziswa komsebenzi we-SUM nokufometha kuma-Google AmaSpredishithi

Ukwengeza imigqa noma izinsika zezinombolo kungenye yezinto ezivame kakhulu ezenziwa kuzo zonke izinhlelo zespredishithi. AmaSpredishithi e-Google ahlanganisa umsebenzi owakhiwe obizwa nge-SUM.

Isici esisodwa esihle sepredishithi yikhono layo lokubuyekeza uma izinguquko zenziwa ngaphakathi kwezingqamuzana zamaseli afingqa. Uma idatha isingeniswe ishintshiwe noma izinombolo zengeziwe kumaseli angenalutho, inani lizobuyekezwa ngokuzenzekelayo ukuze lifake idatha entsha.

Umsebenzi awulahla idatha yombhalo - njengezihloko namalebula - ebangeni elikhethiwe. Faka umsebenzi ngesandla noma usebenzise isinqamuleli kubha yamathuluzi ngemiphumela esheshayo.

Amapredishithi we-Google SUM Umsebenzi we-Syntax nama-Arguments

I- syntax yomsebenzi we-SUM ibhekisela ekufomeni kwefomula yomsebenzi, efaka igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-SUM yilezi:

= SUM (inombolo_1, inombolo_2, ... inombolo_30)

Ama-Arguments Function SUM

Iziphakamiso yizilinganiso umsebenzi we-SUM ozowusebenzisa ngesikhathi sokubala kwawo.

• inombolo_1 - (edingekayo) idatha okufanele ifakwe ngumsebenzi.
• inombolo_2 , ... inombolo_30 - (okukhethwa kukho) amanani angeziwe okumele afingqwe ngamanani angama-30 noma amabanga angafinyelelwa ngomsebenzi.

Ingxabano ngayinye ingaqukatha:

• Inombolo eyodwa okufanele ifingqwe.
• Isithenjwa seseli esibonisa indawo yedatha kushidi lokusebenzela .
• Ububanzi bezinombolo zezingcingo endaweni yedatha kushidi lokusebenzela.

Isibonelo: Engeza ikholomu yezinombolo usebenzisa umsebenzi we-SUM

Njengoba kuboniswe esithombeni esingenhla, lesi sibonelo sizofaka izingqikithi zeseli kuluhlu lwemininingwane okufanele luhlanganiswe umsebenzi we-SUM. Ububanzi obukhethiwe buhlanganisa umbhalo kanye namangqamuzana angenalutho, kokubili okungahambisani nomsebenzi.

Okulandelayo, izinombolo zizozenezwa kulawo maseli angenalutho noma aqukethe umbhalo. Isamba sobubanzi sizovuselela ngokuzenzekelayo ukuze kufaka idatha entsha.

Ukufaka idatha yokufundisa

1. Faka idatha elandelayo kumaseli A1 kuya ku-A6 : 114, 165, 178, umbhalo.
2. Shiya iseli A5 kungenalutho.
3. Faka idatha elandelayo ku- cell A6 : 165.

Ukufaka umsebenzi we-SUM

1. Chofoza kuseli A7 , indawo lapho imiphumela ye-SUM umsebenzi izoboniswa khona.
2. Chofoza ku- Faka > Imisebenzi > I- SUM kwamamenyu ukufaka umsebenzi we-SUM esitokisini A7 .
3. Gqamisa amaseli A1 no-A6 ukuze ufake lolu hlu lwemininingwane njengengxabano yomsebenzi.
4. Cindezela ukhiye wokungena kwikhibhodi.
5. Inombolo 622 kufanele ibonakale esitokisini A7, okungukuthi inani lezinombolo zingeniswe kumaseli A1 kuya ku-A6.

Ibuyekeza umsebenzi we-SUM

1. Thayipha inombolo 200 ibe esitokisini se-A5 bese ucindezela ukhiye we- Enter ekhibhodi.
2. Impendulo 622 esitokisini A7 kufanele ivuselelwe ku-822.
3. Faka esikhundleni idatha yombhalo esitokisini se-A4 ngenombolo 100 bese ucindezela ukhiye we- Enter ekhibhodi.
4. Impendulo ku-A7 kufanele ivuselelwe ku-922.
5. Chofoza kuseli A7 nomsebenzi ophelele = SUM (A1: A6) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela