01 ya 01
Excel SUMPRODUCT Ntchito
Kulemera kwapafupi ndi Kusapitirira Kuchuluka Kwachidule
Kawirikawiri, pamene kuwerengera kawirikawiri kapena masamu kumatanthauza, nambala iliyonse ili ndi mtengo wofanana kapena wolemera.
Ambiri amawerengedwa powonjezera manambala osiyanasiyana pamodzi ndikugawaniza chiwerengerochi ndi chiwerengero cha miyezo.
Chitsanzo chikhoza kukhala (2 + 3 + 4 + 5 + 6) / 5 omwe amapereka pafupifupi osachepera 4.
Mu Excel, ziŵerengero zoterozo zimakhala zosavuta pogwiritsa ntchito NTCHITO ntchito .
Komabe, chiŵerengero cholemera, kumbali inayo, chimawerengera chiwerengero chimodzi kapena zingapo m'mabuku kuti akhale ofunika kwambiri, kapena kukhala ndi kulemera kwakukulu kuposa nambala zina.
Mwachitsanzo, zizindikiro zina kusukulu, monga pakati ndi mayeso omaliza, kawirikawiri zimapindulitsa kuposa mayesero kapena magawo apadera.
Ngati malipiro amagwiritsidwa ntchito kuti azindikire chizindikiro chomaliza cha ophunzira m'katikati ndipo mayeso omaliza adzapatsidwa kulemera kwakukulu.
Mu Excel, chiwerengero cholemera chikhoza kuwerengedwa pogwiritsa ntchito SUMPRODUCT ntchito.
Momwe SUMPRODUCT Ntchito Imagwira Ntchito
Kodi SUMPRODUCT imachita chiyani kuchulukitsa zinthu ziwiri kapena zingapo ndikuwonjezerapo kapena kuwonetsa mankhwala.
Mwachitsanzo, muzochitika zigawo ziwiri zomwe zili ndizinayi zinayi zomwe zimalowa monga zotsutsana ndi ntchito ya SUMPRODUCT:
- choyamba choyamba cha gulu1 chikuchulukitsidwa ndi choyamba choyamba mu gulu2;
- gawo lachiwiri la gulu1 likuchulukitsidwa ndi chigawo chachiwiri cha gulu2;
- gawo lachitatu la gulu1 likuwonjezeka ndi gawo lachitatu la gulu2;
- gawo lachinayi la gulu1 likuwonjezeka ndi gawo lachinayi la gulu2.
Kenaka, zokolola za ntchito zowonjezera zinayi zikufotokozedwa ndi kubwezeredwa ndi ntchito monga zotsatira.
Excel SUMPRODUCT Function Syntax ndi Arguments
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa.
Chidule cha SUMPRODUCT ntchito ndi:
= SUMPRODUCT (array1, array2, array3, ... array255)
Zokambirana za SUMPRODUCT ntchito ndi izi:
ndime 1: (yofunika) mtsutso woyamba.
mndandanda wa magawo awiri, ..., array255: (zosankha) zowonjezereka, mpaka 255. Pogwiritsa ntchito zigawo ziwiri kapena zambiri, ntchitoyi imachulukitsa zinthu zomwe zimagwirizana palimodzi ndikuwonjezera zotsatira.
- zigawo zomwe zingagwiritsidwe ntchito pazomwe zingakhale malo owerengedwa pamasamba kapena ma nambala omwe amalekanitsidwa ndi olemba masamu - monga kuphatikiza (+) kapena zosonyeza (-). Ngati manambala alowa popanda kupatulidwa ndi ogwira ntchito, Excel amawachitira ngati deta. Izi zikupezeka mu chitsanzo pansipa.
Zindikirani :
Zokambirana zonse zikhale zofanana. Kapena, mwa kuyankhula kwina, payenera kukhala chiwerengero chomwecho cha zinthu mu gulu lirilonse. Ngati sichoncho, SUMPRODUCT imabweretsa #VALUE! malingaliro olakwika.
Ngati zinthu zina sizili nambala - monga data deta - SUMPRODUCT amawachitira ngati zeros.
Chitsanzo: Terengani Zolemera Zowirikiza mu Excel
Chitsanzo chowonetsedwa pa chithunzi pamwambachi chiwerengetsera chiwerengero chowerengera cha chizindikiro chomaliza cha wophunzira pogwiritsa ntchito SUMPRODUCT ntchito.
Ntchitoyi ikukwaniritsa izi ndi:
- kukulitsa zizindikiro zosiyanasiyana ndi chinthu chawo cholemera;
- kuwonjezera ntchito za kuchulukitsa uku ntchito pamodzi;
- adagawani ndalama zomwe zili pamwambapa ndi chiwerengero cha chiwerengero cholemetsa 7 (1 + 1 + 2 + 3) kwa mayankho anayi.
Kulowa Mchitidwe Woperekera Thupi
Mofanana ndi zina zambiri mu Excel, SUMPRODUCT nthawi zambiri amalowa mu tsamba pogwiritsa ntchito bokosi la bokosi . Komabe, popeza fomu yolemetsa imagwiritsa ntchito SUMPRODUCT m'njira yosagwirizana - zotsatira za ntchito zimagawidwa ndi cholemera - chiwerengero cholemetsa chiyenera kuikidwa mu selo lamasamba .
Zotsatira izi zidagwiritsidwa ntchito kuti alowe muyeso ya kulemera mu selo C7:
- Dinani pa selo C7 kuti mupange selo yogwira ntchito - malo pomwe chizindikiro chomaliza cha wophunzira chidzawonetsedwa
- Lembani ndondomeko zotsatirazi mu selo:
= SUMPRODUCT (B3: B6, C3: C6) / (1 + 1 + 2 + 3)
Dinani ku key lolowamo pa khibhodi
- Yankho 78.6 liyenera kuoneka mu selo C7 - yankho lanu likhoza kukhala ndi malo ambiri
Osawerengeka osachepera pa zizindikiro zinayi zomwe zikanakhala 76.5
Popeza kuti wophunzirayo anali ndi zotsatira zabwino payekha pakati pake ndi mayeso omaliza, kulemera kwa anthu ambiri kunathandizira kuti apititse patsogolo.
Kusiyana kwa Makhalidwe
Pofuna kutsindika kuti zotsatira za ntchito ya SUMPRODUCT imagawidwa ndi chiwerengero cha zolemera za gulu lirilonse loyesa, wopanga magawo - gawo logawa - linalowa (1 + 1 + 2 + 3).
Lamulo lonse lolemetsa likhoza kukhala losavuta polemba nambala 7 (chiwerengero cha zolemera) monga wopereka malangizo. Njirayi idzakhala:
= SUMPRODUCT (B3: B6, C3: C6) / 7
Kusankha kumeneku kuli bwino ngati chiwerengero cha zinthu zomwe zili ndi zolemetsazo ndizochepa ndipo zikhoza kuwonjezeredwa pokhapokha, koma zimakhala zosavuta ngati chiwerengero cha zinthu zolemetsa chikuwonjezera kuwonjezera kuwonjezera.
Njira ina, ndipo mwinamwake chisankho chabwino - popeza chimagwiritsa ntchito mafotokozedwe a selo m'malo mowerengera manambala mu chiwerengero cha otsogolera - zikhoza kugwiritsa ntchito ntchito ya SUM kuti ikhale yowonjezereka ndi njirayi:
= SUMPRODUCT (B3: B6, C3: C6) / SUM (B3: B6)
Kawirikawiri zimakhala bwino kuti mulowetse maumboni ang'onoang'ono m'malo mwa nambala yeniyeni kuti mukhale njira zowonjezera ngati zikuwongolera kuwunika ngati deta yanu ikusintha.
Mwachitsanzo, ngati zinthu zolemetsa zogwira ntchito zasinthidwa kukhala 0,5 mu chitsanzo ndi mayesero a 1.5, mayina awiri oyambirirawo angasinthidwe mwakachetechete kuti awongolere.
Mwachigawo chachitatu, deta yokha mu maselo B3 ndi B4 akuyenera kusinthidwa ndipo mayendedwewa adzakonzanso zotsatirazo.