Pulogalamu AVERAGEIF: Pezani Average for Specific Criteria

Ntchito ya AVERAGEIF imaphatikizapo ntchito ya IF ndi AVERAGE ntchito ku Excel. Kuphatikizanaku kukupatsani mwayi wopezera masewera kapena masamu omwe amatanthauzira mfundo zomwe zimasankhidwa.

IF IF gawo la ntchitoyi limatsimikizira kuti deta ikukhudzana ndi zifukwa zotani ndipo GAWO la GAWO limawerengera pafupifupi kapena kutanthauza.

Kawirikawiri, AVERAGE IF imagwiritsidwa ntchito ndi mizere ya data yotchedwa ma rekodi. M'mbuyo , deta yonse mu selo iliyonse mzere ikugwirizana - monga dzina la kampani, adiresi ndi nambala ya foni.

AVERAGE IF ikuyang'ana zoyenera mu selo imodzi kapena munda m'makalata ndipo, ngati ipeza machesi, iwerengetsera deta kapena deta ina mu malo ena omwe ali ndi mbiriyo.

Momwe ntchito ya AVERAGEIF ntchito

Maphunzirowa amagwiritsa ntchito NTCHITO YA CHIKHULUPIRIRO IF kupeza mndandanda wa malonda chaka chilichonse ku East East chiwerengero cha deta.

Kutsatira ndondomeko m'mitu yophunzitsira pansipa ikukuyendetsani kupyolera mukupanga ndi kugwiritsa ntchito NTCHITO YA CHIKHALAPO IF kuwonetseredwa mu chithunzi pamwambapa kuti muwerenge malonda a pachaka.

Mitu Yophunzitsa

• Kulowa Datorial Data
• CHIYAMBI Ngati Syntax ya Ntchito
• Kuyambira PANTHAUZO IF Function
• Kulowa Mtsutso Wokambirana
• Kulowa Mtsutso Wotsutsa
• Kulowetsa Wophatikiza_kutsutsana
• Ndipo Yankho liri ..

Kulowa Datorial Data

Njira yoyamba yogwiritsira ntchito NTCHITO YA IFE IF ntchito mu Excel ndiyolowetsa deta .

Lowani deta mu maselo C1 mpaka E11 a pepala la Excel monga momwe tawonera pa chithunzi pamwambapa.

Zindikirani: Mauthenga a maphunziro saphatikizapo kukonza mapepala a tsamba.

Izi sizidzasokoneza kukwaniritsa maphunziro. Tsamba lanu la ntchito lidzawoneka mosiyana ndi chitsanzo chowonetsedwa, koma ntchito ya AVERAGE IF idzakupatsani zotsatira zomwezo.

Zambiri pazomwe mungapangire zofanana ndi zomwe tawonera pamwambazi zikupezeka mu phunziroli la Basic Excel Formatting .

Syntax ya Ntchito ya AVERAGEIF

Mu Excel, syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakita, ndi zifukwa .

Chidule cha AVERAGEIF ndi:

= AVERAGEIF (Range, Criteria, Average_range)

Maganizo a Ntchito ya AVERAGEIF

Mfundo zokhudzana ndi ntchitoyi zimapangitsa kuti ntchito iziyendera bwanji komanso kuti ndi chiwerengero chiti cha deta kuti chiwerengedwe chikhale chotani.

Mtundu - gulu la maselo ntchitoyo ndi kufufuza.

Zolinga - mtengo uwu umafanizidwa ndi deta mu Range. Ngati macheza amapezeka ndiye kuti ma data omwe ali nawo mu Average_range ndi owerengeka. Dongosolo lenileni kapena mawonekedwe a selo pa deta angalowetsedwe pazitsutsano izi.

Average_range (zosankha) - deta yomwe ili m'maselo angapo amawerengeka pamene masewera amapezeka pakati pa ziganizo za Range ndi Criteria. Ngati ndemanga ya Average_range yanyalanyaza, deta yomwe ikufanana muyiyiyi yayikapo m'malo mwake.

Kuyambira ntchito ya AVERAGEIF

Ngakhale kuti n'zotheka kungoyamba ntchito YAM'MBUYO YAM'MBUYO YAM'MBUYO YOTSATIRA TUMIZANI LINKI SINDIKIZANI KOPERANI Magazini Mabuku Nyimbo Mavidiyo Zina ... NKHANI ZOTHANDIZA Anthu Apabanja Ndiponso Makolo Achinyamata Ana PEZANI

Maphunziro Otsogolera

1. Dinani pa selo E12 kuti mupange selo yogwira ntchito . Apa ndi pamene tidzalowa ntchito YOULEMBI IF.
2. Dinani pa Fomu tab ya riboni .
3. Sankhani Ntchito Zambiri> Chiwerengero chochokera ku riboni kuti mutsegule ntchitoyi.
4. Dinani pa WOULEMBA IF mu mndandanda kuti abweretse bokosi la MAFUNSO A CHIKHULUPIRIRO CHA IFU.

Deta yomwe timalowa muzitsulo zitatu zopanda kanthu mu bokosi la zokambirana zidzakhazikitsa zifukwa za ntchito YAPA IF.

Zokambirana izi zimapereka ntchito yomwe tikuyesera ndipo ndi deta yamtundu wanji yomwe imakhala yeniyeni pamene vutoli likumane.

Kulowa Mtsutso Wokambirana

Mu phunziro ili tikuyang'ana kuti tipeze malonda a pachaka a chigawo cha East East.

Mtsutso wa Range umati ku AVERAGE IF ntchito yomwe gulu la maselo lifufuze pamene likuyesera kupeza zoyenera - East.

Maphunziro Otsogolera

1. Mu bokosi la bokosi , dinani pa Range line.
2. Onetsetsani maselo C3 mpaka C9 mu tsamba lolemba kuti mulowetse maumboni a maselowa ngati momwe mungathere pofufuza.

Kulowa Mtsutso Wotsutsa

Mu chitsanzo ichi ngati deta yomwe ili pakati pa C3: C12 ikufanana ndi East ndiye malonda onse a mbiriyo ayenera kuwerengedwa ndi ntchitoyi .

Ngakhale chidziwitso chenicheni - monga mawu a East chingalowe mu bokosi lazokambirana pazokambirana izi ndi bwino kuwonjezera deta mu selolo pa tsambalo ndiyeno lowetsani selolo mulokosi.

Maphunziro Otsogolera

1. Dinani pa mzere wa zofunikira mu bokosi la dialog .
2. Dinani pa selo D12 kuti mulowetse selolo. Ntchitoyi idzafufuza zosankhidwa zomwe zasankhidwa kumbuyo kwa deta yomwe ikugwirizana ndi izi.
3. Nthawi yofufuzira (Kummawa) idzawonjezedwa ku selo D12 mu sitepe yotsiriza ya phunzirolo.

Mafotokozedwe a Magulu Awonjezere Ntchito Yophatikizapo

Ngati mafotokozedwe a selo, monga D12, alowetsedwa ngati Chotsutsana ndi Zokakamiza, ntchito ya AVERAGE IF idzayang'ana machesi kwa chirichonse chomwe chidaikidwa mu selololo pa tsamba.

Choncho mutatha kupeza malonda ambiri ku dera lakummawa, zidzakhala zosavuta kuti mupeze malonda ambiri ku malo ena ogulitsa pogwiritsa ntchito kusintha East mpaka North kapena West. Ntchitoyi idzangosintha ndi kusonyeza zotsatira zatsopano.

Kulowetsa Wophatikiza_kutsutsana

Mtsutso wa Average_range ndi gulu la maselo omwe ntchitoyo ndiyomwe imawoneka pamene ikupeza machesi mu ndondomeko ya Range yomwe ikupezeka mu sitepe 5 ya phunziroli.

Mtsutso uwu ndi wosankha ndipo, ngati sungalephereke, Excel ndiyonse maselo omwe akufotokozedwa m'nkhani ya Range.

Popeza tikufuna pafupifupi malonda ku dera la East sales timagwiritsa ntchito deta mu Total Sales column monga ndemanga ya Average_range.

Maphunziro Otsogolera

1. Dinani pa mzere wa Average_range mu bokosi la bokosi.
2. Sungani maselo E3 ku E9 pa spreadsheet. Ngati zofunikira zomwe zatchulidwa mu sitepe yapitayi zikufanana ndi deta iliyonse yoyamba (C3 mpaka C9), ntchitoyo idzawonetsera deta m'maselo ofanana ndi maselo awiriwa.
3. Dinani OK kuti mutseke bokosi la kukambirana ndi kumaliza ntchito YOTSATIRA IF.
4. A # DIV / 0! Cholakwika chidzawoneka mu selo E12 - selo yomwe talowa mu ntchito chifukwa sitinayambe kuwonjezera deta kumunda wa Criteria (D12).

Kuwonjezera Zofuna Zosaka

Gawo lomaliza la phunziroli ndi kuwonjezera zomwe tikufuna kuti ntchitoyi ikhale yogwirizana.

Pankhaniyi tikufuna kupeza malonda a pachaka a malonda a ku East region kotero kuti tiwonjezerepo East mpaka D12 - selo lozindikiritsidwa mu ntchito monga liri ndi ndondomeko yoyenera.

Maphunziro Otsogolera

1. Mu selo la D12 mtundu wa East ndipo dinani fungulo lolowani mukibokosi.
2. Yankho la $ 59,641 liyenera kuoneka mu selo E12. Popeza kuti kulingana kwa East kumagwirizanitsidwa m'maselo anayi (C3 mpaka C6) chiwerengero cha maselo omwe ali ofanana mu gawo E (E3 mpaka E6) ndi owerengeka.
3. Mukasindikiza pa selo E12, ntchito yonse
   = AVERAGEIF (C3: C9, D12, E3: E9) ikuwoneka muzenera zamatabwa pamwamba pa tsamba .
4. Kuti mupeze malo ogulitsa malonda ena, tchulani dzina la dera, monga kumpoto mu selo E12 ndikusindikizira Enter key pa makiyi.
5. Chiwerengero cha dera la malondacho chiyenera kuonekera mu selo E12.