SUMPRODUCT ntchito mu Excel ndi ntchito yodabwitsa kwambiri yomwe idzapereka zotsatira zosiyana malingana ndi zomwe zanenedwa.
Zomwe SUMPRODUCT ntchito zimakhala zikuchulukitsa zinthu za chimodzi kapena zingapo zomwe zimaphatikizapo ndikuwonjezerapo kapena kuwonetsa katundu pamodzi.
Koma powasintha mawonekedwe a zotsutsana, SUMPRODUCT idzawerengera chiwerengero cha maselo mumtundu wapadera womwe uli ndi deta yomwe imakwaniritsa zofunikira.
01 a 04
SUMPRODUCT vs. COUNTIF ndi COUNTIFS
Kuchokera ku Excel 2007, pulogalamuyo ili ndi ntchito COUNTIF ndi COUNTIFS zomwe zingakuthandizeni kuwerengera maselo omwe amakwaniritsa njira imodzi kapena zingapo.
Komabe, nthawi zina, SUMPRODUCT ndi yosavuta kugwira ntchito pofufuza zinthu zambiri zofanana ndi zomwe zikuwonetsedwa mwachitsanzo zomwe zili mu chithunzi pamwambapa.
02 a 04
SUMPRODUCT Ntchito Yogwirizanitsa Syntax ndi Arguments Kuwerengera Maselo
Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .
Kuti ntchitoyi ikhale yowerengera maselo m'malo mochita cholinga chake, izi ziyenera kusagwiritsidwa ntchito ndi SUMPRODUCT:
= SUMPRODUCT ([condition1] * [condition2])
Kufotokozera momwe mawu ogwiritsira ntchitowa akufotokozera pansipa chitsanzo chotsatira.
Chitsanzo: Kuwerengera Maselo Amene Amakumana Ndi Mavuto Ambiri
Monga momwe tawonera mu chitsanzo cha chithunzi pamwambapa, SUMPRODUCT imagwiritsidwa ntchito kupeza chiwerengero cha maselo mu deta ya A2 mpaka B6 yomwe ili ndi deta pakati pa chikhalidwe cha 25 ndi 75.
03 a 04
Kulowa ntchito ya SUMPRODUCT
Kawirikawiri, njira yabwino kwambiri yolowera ntchito ku Excel ndi kugwiritsa ntchito bokosi lawo , zomwe zimapangitsa kuti zikhale zosavuta kulowetsamo mfundo imodzi pokha popanda kulowetsa mabakiteriya kapena makasitomala omwe amachititsa kuti azikhala osiyana pakati pazitsutso.
Komabe, chifukwa chitsanzo ichi chimagwiritsa ntchito mawonekedwe osasintha a SUMPRODUCT ntchito, njira ya dialog box sungagwiritsidwe ntchito. M'malo mwake, ntchitoyo iyenera kuyimilidwa mu selo lamasamba .
Mu chithunzi pamwambapa, ndondomeko zotsatirazi zinagwiritsidwa ntchito kulowa SUMPRODUCT mu selo B7:
- Dinani pa selo B7 mu tsamba la ntchito - malo omwe zotsatira zotsatira zidzasonyezedwe
- Lembani ndondomeko yotsatirayi mu selo E6 la ofunsira:
= SUMPRODUCT (($ A $ 2: $ B $ 6> 25) * ($ A $ 2: $ B $ 6 <75))
- Yankho lachisanu liyenera kuoneka mu selo B7 popeza pali zigawo zisanu zokha - 40, 45, 50, 55, ndi 60 - zomwe ziri pakati pa 25 ndi 75
- Mukasindikiza pa selo B7 ndondomeko yomalizidwa = SUMPRODUCT (($ A $ 2: $ B $ 6> 25) * ($ A $ 2: $ B $ 6 <75)) ikupezeka mu barolo yamapangidwe pamwamba pa tsamba
04 a 04
Kuphwanya SUMPRODUCT Ntchito
Pamene mikhalidwe imayikidwa pazitsutsano, SUMPRODUCT imayang'ana mbali iliyonse yotsutsana ndi vutoli ndipo imabweretsanso mtengo wa Boolean (WOONA kapena WOKHALA).
Kwa cholinga chowerengera, Excel imapereka mtengo wa 1 pa zinthu zomwe zili zoona ndi mtengo wa 0 kuti zikhale zosiyana.
Zofanana ndi zeros m'gulu lililonse zimachulukana palimodzi:
- ndi 1 x 1 kubwezera mtengo wa 1
- ndi 1 × 0 kubwezera mtengo wa 0
Izi ndi zeros zikuphatikizidwa ndi ntchito kutipatsa ife chiŵerengero cha miyezo yomwe imayendera zonsezi.
Kapena, taganizirani izi motere ...
Njira yina yoganizira zomwe SUMPRODUCT ikuchita ndikuganiza za chizindikiro chochulukitsa monga chikhalidwe.
Ndili ndi malingaliro, ndizochitika pamene ziwiri zonsezi zatha - ziwerengero zazikulu zoposa 25 ndi zosachepera 75 - kuti mtengo weniweni (womwe uli wofanana ndi womwe ukukumbukira) ukubwezedwa.
Ntchitoyo imaphatikizapo ziwerengero zonse zowona kuti zifike pamapeto a 5.