Sida loo dhufanaynaa khaanadda Excel by column, iyo tiirka on tirada

dadka Kuwa inta badan ka shaqeeyaan computer ka, ha dhawaado ama ha la kulantay barnaamij sida Excel. Laakiin wadahadalka ee maqaalka socda oo dhan faa'iidada iyo khasaaraha barnaamijka, iyo wax ku saabsan qaybaha shaqsi ay, "Formula". Dabcan, dugsiyada iyo jaamacadaha on sayniska casharada ardayda iyo ardayda qaadan koorso ku saabsan mowduuca, laakiin kuwa iska illoobeen - our article.

Waxaan ka hadli doonaa sida leysugu dhufto column Excel si column. Waxay ku siin doonaan tilmaamaha faahfaahsan oo ku saabsan sida loo sameeyo, iyadoo talaabo falanqaynta tallaabo of item kasta, si qof walba, xataa ardayga laylis ay awood u eegto arrinta noqon doonaa.

Tarma column by column

Sida loo dhufanaynaa khaanadda Excel by column, waxaan ku fadhiisan doonaa tusaale ahaan. Aynu qiyaasi in buugga Excel aad la abuuro miis iyadoo qiimaha iyo tirada alaabta. Waxa kale oo aad gacanta hoos ugu lacagta total. Sida laga yaabo in aad u maleynayaa in, aad u baahan tahay in si deg deg ah u badin labada tiirar ugu horeysay oo ay helaan ay wadarta.

Sidaas, halkan waa tallaabo by tilmaamaha tallaabo:

1. Muujiyo meesha la doonayo oo riix function icon ah, oo ku yaalla sare ee toolbar ugu weyn.
2. window "Qaar kale" ayaa laga xulan doonaa muuqataa idinka soo hor jeedda meesha aad rabto.
3. Next, waa in aad kala dooran koox ka mid ah hawlaha xisaabta.
4. Dooro "SUMPRODUCT".

Ka dib markii in, daaqad u muuqataa in taas lagu weydiiyo in aad doortaan kala duwan oo ay ku jiraan xogta, waxaad tagi kartaa laba siyaabood. Midkii kowaad wuxuu u tilmaamaysaa in aad isticmaasho dulqabo in ay doortaan column ugu horeysay (qiimaha), oo ay kala duwan waxaa loo cayimay ee "Array 1", iyo labaad (qiimaha) - waxaa ku qoran ee "Array 2". Sida aad arki karto, kala duwan oo la cayimay ee characters (C2: C6). Habka labaad waxa ay tilmaamaysaa in aad gacanta geli doono qiimayaashan, farqiga ka jirin this.

Hadda waxaad ogaan hal hab sida leysugu dhufto ee column Excel by column, laakiin ma aha mid ka mid ah oo kaliya, iyo kii labaad la oran hadli doonaa.

Habka labaad isu-dhufasho

Si aad u tarmin columns habka labaad, waxa kale oo aad u baahan doontaa in ay doortaan "xisaabta" koox shaqo, laakiin hadda waxaan u leeyihiin in ay isticmaalaan "dhigi". Hadda waxaa jira laba beeraha idinka soo hor jeedda, "Number 1" iyo "lambarka 2". Click on the "Number 1" dooro qiimaha ugu horeysay ka column ugu horeysay, sida lagu celiyo oo la "Number 2", kaliya doorta qiimaha ugu horeysay ee column labaad.

Ka dib markii riixaya "OK" in gacanta la formula wuxuu noqon doonaa wax soo saarka ee qiimaha la doortay, soo saari karaan oo kaliya unugyada Meesha buuxinta, waayo, taasu, guurto dulqabo cidhifka hoose saxda ah ee gacanta iyo waxa jiidi hoos si tirada loo baahan yahay ee dhibcood.

Hadda waxaad baratay hab labaad ee sida leysugu dhufto ee column Excel by column. Hadda aan ka hadalno sida leysugu dhufto tirada column ah.

Tarma by tirada column

Sidaas, sida leysugu dhufto column ah ee Excel tirada? Dhab ahaantii, waxaa xitaa fudud. Si arrintan loo sameeyo:

1. Dooro cell halkaas oo natiijada laga dhisi doonaa.
2. Gala ee calaamada "isku mid".
3. dulqabo The muujineysaa qiimaha ugu horeysay ee khaanadda, laakiin waa in la qoondeeyay tirada ay u badin doonaa qiimaha.
4. Ka dib markii in, ka guurto dulqabo in tirada iyo saxaafadda F4 ah.
5. Waxaa hadda weli kaliya saaray dulqabo on geeska hoose ee midig ee jawaabta cell iyo waxa jiidin tirada doonayo ee alaabta.