Samee Isticmaalka Mashruuca SOMPRODUCT si loo tiriyo shuruudaha kala duwan

Mashruuca COUNTIFS, oo loo isticmaali karo in lagu tiriyo tirada xogta wakhtiyada laba ama wax ka badan oo unugyo ah ayaa la kulmaa shuruudo badan markii hore lagu soo bandhigay Excel 2007. Ka hor intaan, COUNTIF oo keliya ayaa loogu talagalay in lagu tiriyo tirada unugyada noocyo kala duwan oo la kulmay hal shey oo kale, ayaa la heli karaa.

Kuwa isticmaalaya Excel 2003 ama kuwa hore, ama kuwa doonaya inay bedelaan COUNTIFS, halkii ay isku dayi lahaayeen inay ku xisaabtamaan habka lagu xisaabayo shuruudo badan iyadoo la adeegsanayo COUNTIF, adeegga SUMPRERT ayaa loo isticmaali karaa halkii.

Sida COUNTIFS, kala duwanaanta loo adeegsado SUMPRTT waa inay ahaato mid isku mid ah.

Dheeraad ah, shaqadu waxay tirineysaa marxaladaha shuruudaha kala duwan ee loo siman yahay - isla sida isku midka ah.

Sida loo isticmaalo SUMPRODUCT Function

Ereyga loo isticmaalo hawlgalka SUMPRODUCT marka loo isticmaalo in lagu tiriyo shuruudo badan ayaa ka duwan inta caadiga ah ee loo adeegsado shaqeynta:

= SUMPRODUCT (Criteria_range-1, Criteria-1) * (Criteria_range-2, Criteria-2) * ...)

Criteria_range - kooxda unugyada shaqadu waa inay raadiyaan.

Shuruudaha - waxay go'aaminayaan in unugyada la tirin doono iyo haddii kale.

Tusaalahan hoos ku xusan, waxaan ku xisaabin doonaa oo kaliya safarka ku jira tusaalaha xogta E1 ilaa G6 ee soo buuxiya shuruudaha loogu talagalay dhammaan sadarka xogta.

Safafka waxaa lagu tirin doonaa oo kaliya haddii ay buuxiyaan shuruudaha soo socda:
Salka E: haddii lambarkiisu ka yaryahay ama ka siman yahay 2;
Qeybta F: haddii lambarku u eg yahay 4;
Sadarka G: haddii lambarka uu ka weyn yahay ama la eg yahay 5.

Tusaale Isticmaalidda Isticmaalka Excel SUMPRODUCT Function

Xusuusin: maaddaama tani ay tahay mid aan caadi aheyn isticmaalka SUMPRODUCT Function, howlaha lama geli karo isticmaalka sanduuqa wada hadalka , laakiin waa in lagu qoraa unugta bartilmaameedka.

1. Ku qor xogta soo socota unugyada E1 ilaa E6: 1, 2, 1, 2, 2, 8.
2. Ku qor xogta soo socota unugyada F1 ilaa F6: 4, 4, 6, 4, 4, 1.
3. Ku qor xogta soo socota unugyada G1 ilaa G6: 5, 1, 5, 3, 8, 7.
4. Riix batoonka I1 - meesha meesha natiijooyinka ficilada la soo bandhigi doono.
5. Ku qor kuwaan soo socda ee unugyada I1:
   1. = Macaamilka ((E1: E6 <= 5) * (F1: F6 = 4) * (E1: E6> = 5)) oo riix fure ' Enter' key keyboard.
6. Jawaabta 2 waa inay ka muuqataa unugyada I1 maaddaama ay jiraan laba saf (oo ah darajooyinka 1 iyo 5) oo ka soo baxa dhammaan saddexda shuruudood ee kor ku xusan.
7. Foomka dhammaystiran = SUMPRODUCT ((E1: E6 <= 5) * (F1: F6 = 4) * (E1: E6> = 5)) ayaa ku muuqda miiska qaabka kore ee warqadda shaqada markii aad gujiso unugyada I1.