I-Excel AVERAGEIF: Fumana umyinge weeNqobo eziPhezulu

Umsebenzi we-AVERAGEIF udibanisa umsebenzi we-IF kunye ne- AVERAGE umsebenzi kwi-Excel. Le nhlanganisela ikuvumela ukuba ufumane isingqinisiso okanye i-arithmetic intsingiselo yalezo zithethe kwiinkalo ezikhethiweyo zedata ezihlangabezana neenkcazo ezithile.

I-IF inxenye yomsebenzi inquma ukuba yiyiphi idata edibana neenkcazo ezichaziweyo kunye neCANDELO SENQUBO sinquma umyinge okanye uthetha.

Ngokuqhelekileyo, UKUPHATHWA KWENKQUBO kusetyenziswa ngemigca yedatha ebizwa ngokuba yiirekhodi. Kwirekhodi , zonke iinkcukacha kwiselinye nganye kumqolo zihlobene - njengegama lenkampani, idilesi nenombolo yefowuni.

ISIGABA UKUBA ikhangele iikhrayitheriya ezithile kwisitye enye okanye kwintsimi kwirekhodi kwaye, ukuba ithola umdlalo, imilinganiselo yokuba idatha okanye idatha kwenye indawo echaziweyo kwirekhodi efanayo.

Indlela Umsebenzi we-AVERAGEIF osebenza ngayo

Le tutorial isebenzisa umsebenzi we-AVERAGE IF ukufumana ukuthengiswa kweminyaka ephakathi kwendawo yokuthengisa yaseMpuma kwiiseti zeedatha.

Ukulandela amanyathelo kwizihloko ezifundiswa ngezantsi kuhamba ngokudala kunye nokusebenzisa umsebenzi we-AVERAGE IF ebonwayo kumfanekiso ongentla ukubala ukuthengiswa kweminyaka.

Izihloko zeTutorial

• Ukufaka i-Tutorial Data
• ISISHWANKATHELO SOKUBA I-Syntax Yomsebenzi
• Ukuqala ISIGABA SOKUBA UMSEBENZI
• Ukungena kwi-Arange Point
• Ukungena kwiNkcazo yokuPhikisana
• Ukungena Umyinge_migqaliselo
• Yaye impendulo i ..

Ukufaka i-Tutorial Data

Isinyathelo sokuqala sokusebenzisa umsebenzi we-AVERAGE IF kwi-Excel ukufaka idatha .

Faka idatha kwiiseli C1 ukuya kwi-E11 kwiphepha lokusebenzela lase Excel njengoko kuboniswa kumfanekiso ongentla.

Qaphela: Imiyalelo yokufundisa ayifaki ukufomatha amanyathelo kwiphepha lokusebenzela.

Oku akuyi kuphazamisana nokugqiba uqeqesho. Iphepha lokusebenzela liya kubonakala lihlukile kunomzekelo obonisiweyo, kodwa umsebenzi we-AVERAGE IF uza kukunika iziphumo ezifanayo.

Ulwazi malunga nokufometha okukhethiweyo kufana nalabo abonwe ngentla lufumaneka kule Siseko yoQuquzelelo lwe-Excel .

I-Syntax ye-AVERAGEIF yeSebenzi

Kwi-Excel, i- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, amabakaki kunye neengxabano .

I-syntax yeAVERAGEIF yile:

= I-AVERAGEIF (I-Range, iCriteria, Umyinge-umda)

I-AVERAGEIF Iingxoxo zeeNkonzo

Iingxoxo zomsebenzi zixelela umsebenzi ukuba yiyiphi imeko ehlolwe ngayo kwaye uluphi udidi lweedatha kumlinganiselo xa loo mqathango idibene.

Ububanzi - iqela leeseli umsebenzi ukukhangela.

Iimpawu - eli xabiso lithelekiswa nedatha kwiRange. Ukuba umdlalo ufunyenwe kwaye idatha ehambelanayo kwi-Average_range isilinganiso. Idatha ekhoyo okanye iselferensi yeselfayile ingeniswa kule ngxabano.

Umyinge-umda (ukhetho) - idatha kuloluhlu lweeseli lilinganiselwe xa imifuno ifunyenwe phakathi kweMigangatho neMigqaliselo. Ukuba impikiswano ye-Average_range argument ishiywe, idatha ehambelana kwi-argument yeRange isithuba endaweni.

Ukuqala ukusebenza kwe-AVERAGEIF

Nangona kunokwenzeka ukuba uthayiphe nje umsebenzi we-AVERAGE IF kwisisele , abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko yencoko yomsebenzi ukuba wonge umsebenzi kwiphepha lokusebenzela .

Iimfundiso zeTutorial

1. Cofa kwiseli E12 ukwenzela ukuba yenze iseli esebenzayo . Le yilapho esiya kufaka umsebenzi we-AVERAGE IF.
2. Cofa kwiThebhu yefomula yerbhoni .
3. Khetha Imisebenzi Engakumbi> Isitatisti kwibhebhoni ukuvula uluhlu lokuhla kwehla.
4. Cofa kwi-ASIGHT IF kule uluhlu ukukhupha ibhokisi yencoko yencoko ye-ASVER IF.

Idata esifakayo kwimigca emithathu engenanto kwibhokisi yencoko iya kubumba iingxoxo ze-AVERAGE IF function.

Ezi ngxabano zitsho umsebenzi yintoni na imeko esiyivavanya ngayo kwaye uluphi udidi lweedatha kumyinge xa ​​imeko idibeneyo.

Ukungena kwi-Arange Point

Kule ngqeqesho sifuna ukufumana ukuthengiswa kweminyaka ephakathi kwendawo yokuthengisa eMpuma.

Ingxabano yeRange ixelela umsebenzi we-AVERAGE IF iqela leeseli ukukhangela xa uzama ukufumana iindlela ezichaziweyo-eMpuma.

Iimfundiso zeTutorial

1. Kwibhokisi yencoko , nqakraza kumgca weRange .
2. Gqamisa iiseli C3 ukuya ku-C9 kwiphepha lokusebenzela ukuze ufake ezi ngqamaniso zeeseli njengoluhlu oluza kuphandwa ngumsebenzi.

Ukungena kwiNkcazo yokuPhikisana

Kulo mzekelo ukuba idatha kwibala C3: C12 ilingana neMpuma ngoko ukuthengiswa ngokupheleleyo kwirekhodi kuya kufakwa ngumsebenzi .

Nangona idatha yangempela - njengegama laseMpumalanga lingeniswa kwibhokisi yencoko yababini le ngxabano kulungele ukongeza i-data kwisisele kwiphepha lomsebenzi uze ufake ifowuni yencoko kwibhokisi yencoko.

Iimfundiso zeTutorial

1. Cofa kwiNgcaciso yomgca kwibhokisi yencoko .
2. Cofa kwifowuni D12 ukungena kuloo fowuni yereferensi. Umsebenzi uya kukhangela uluhlu olukhethwe kwinqanaba elidlulileyo lwedatha efana nale migaqo.
3. Ixesha lokusesha (eMpuma) liya kwongezwa kwiseli D12 kwisinyathelo sokugqibela sesifundo.

Iingxelo zeeNgcono ziKongeza ukuSebenzisana kweMisebenzi

Ukuba isalathisi seeseli, njenge-D12, ingeniswa njengeCriteria Argument, umsebenzi we-AVERAGE IF uza kukhangela imifuno kuyo nayiphi na idatha efakwe kulolu hlobo kwishidi lomsebenzi.

Ngoko emva kokufumana ukuthengisa okuqhelekileyo kwiphondo laseMpuma kuya kuba lula ukufumana ukuthengisa okuqhelekileyo kwesinye iindawo ezithengisayo ngokushintsha iMpuma ukuya eNyakatho okanye eNtshona. Umsebenzi uya kuhlaziya ngokuzenzekelayo kwaye ubonise umphumo omtsha.

Ukungena Umyinge_migqaliselo

Ingxabano ye- Average_range argument yiqela leeseli ezenza umyinge xa ​​zifumana umdlalo kwiingxoxo zeRange ezibonwe kwisinyathelo sesi-5 se-tutorial.

Le ngxabano ikhethiweyo kwaye, xa ikhutshwe, i-Excel imilinganiselo iiseli ezichazwe kwingxabano yeRange.

Ekubeni sifuna ukuthengisa okuqhelekileyo kwingingqi yokuthengisa yaseMpuma sisebenzisa idatha kwikholamu yokuThengiswa ngokuPhezulu njenge-Average_range argument.

Iimfundiso zeTutorial

1. Cofa kumgca-umgca-umgca kwibhokisi yencoko.
2. Gqamisa iiseli E3 ukuya ku-E9 kwi-spreadsheet. Ukuba imigaqo echazwe kwinqanaba elidlulileyo lifanisa nayiphi na idatha kwibanga lokuqala (iC3 ukuya ku-C9), umsebenzi uya kufaka i-data kwiiseli ezihambelanayo kule nqanaba lesibini leeseli.
3. Cofa u- OK ukuvala ibhokisi yencoko kwaye uqedele umsebenzi we-AVERAGE IF.
4. I- # DIV / 0! Iphutha liya kubonakala kwiseli E12 - iseli apho singene khona kumsebenzi ngenxa yokuba asikazanga ukongeza idatha kwi-Criteria field (D12).

Ukongeza iCriteria Criteria

Isinyathelo sokugqibela kwisifundo kukudibanisa imigaqo esifuna ukuba umsebenzi uhambelane.

Kule meko sifuna ukufumana ukuthengiswa kweminyaka ngonyaka yokuthengiswa kwee-reps kummandla waseMpuma ngoko siza kwengeza i- East ukuya kwi-D12- iseli echongwe kumsebenzi njengoko iqulethe ingqinamba yokuchasana .

Iimfundiso zeTutorial

1. Kwiseli yeD12 yohlobo lwaseMpuma kwaye cinezela ukhiye we- Enter kwibhodibhodi.
2. Impendulo eyi-59,641 i-$ imele ibonakale kwiseli ye-E12. Ekubeni umlinganiselo wokulingana kweMpuma udibene kwiiseli ezine (C3 ukuya ku-C6) amanani kwiiseli ezihambelanayo kwikholam ye-E (E3 ukuya kwi-E6) zilinganiselwe.
3. Xa ucofa kwiseli E12, umsebenzi opheleleyo
   = AVERAGEIF (C3: C9, D12, E3: E9) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela .
4. Ukufumana umyinge wokuthengisa kwezinye iindawo zokuthengisa, thayipha igama lommandla, njengeNyakatho kwiseli E12 kwaye ucinezela ukhiye wokungena kwikhibhodi.
5. Umyinge waloo mmandla wokuthengisa kufuneka uvele kwi-cell E12.