Excel AVERAGEIF: Nemi Ma'anar Ainihin Musamman

Ayyukan AVERAGEIF ya hada aikin IF da aikin AVERAGE a Excel. Wannan haɗin yana ba ka damar samun mahimmanci ko mahimmanci na ma'anar waɗannan dabi'un a cikin jerin abubuwan da aka zaɓa da suka dace da ka'idodi.

Da IF wani ɓangare na aikin yana ƙayyade abin da bayanai ke haɗu da ƙayyadaddun ka'idodi da kuma ɓangaren ƙungiyar AVERAGE ya ƙayyade matsakaicin ko ma'ana.

Yawanci, ana amfani da AVERAGE IF tare da layuka bayanai da ake kira records. A cikin rikodin , duk bayanai a kowane tantanin halitta a jere suna da alaƙa - kamar sunan kamfanin, adireshin da lambar waya.

BABI NA BIKE yana neman takamaiman ma'auni a cikin tantanin halitta guda ko filin a cikin rikodin kuma, idan ya samo wani wasan, ana nuna nauyin cewa bayanai ko bayanai a wani filin da aka ƙayyade a cikin wannan rikodin.

Yaya aikin Ayyukan BAYANYA

Wannan koyaswar tana amfani da aikin AVERAGE IF don samun yawan tallace-tallace na shekara shekara ga yankin tallace-tallace na Gabas a cikin jerin bayanan bayanan.

Biye matakai a cikin darussan koyawa da ke ƙasa ke tafiya ta hanyar samar da amfani da aikin AVERAGE IF a cikin hoton da ke sama don ƙididdiga yawan tallace-tallace a shekara.

Tutorial Topics

• Shigar da Bayanan Tutorial
• BABI NA BAYA Idan Haɗin aiki yake
• Fara Farawa Idan Hanya
• Shigar da Magana na Range
• Shigar da Sharuddan Magana
• Shigar da Magana na Arma'in da Ƙarin
• Kuma Amsar ita ce ..

Shigar da Bayanan Tutorial

Mataki na farko don yin amfani da aikin AVERAGE IF a Excel shine shigar da bayanai .

Shigar da bayanai zuwa cikin sassan C1 zuwa E11 na takardar aiki na Excel kamar yadda aka gani a cikin hoto a sama.

Lura: Umurni na koyawa ba sun haɗa da matakan tsarawa don aikin aiki ba.

Wannan ba zai dame shi ba tare da kammala tutorial. Kayan aikinku zai bambanta da misalin da aka nuna, amma aikin AVERAGE IF zai ba ku sakamakon wannan.

Zaɓuɓɓukan bayani game da tsarin tsarawa kamar waɗanda aka gani a sama suna samuwa a wannan Basic Tutel Tutorial .

Hanyoyin aikin aikin AVERAGEIF

A cikin Excel, haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, da muhawara .

Haɗin na AVERAGEIF shine:

= AVERAGEIF (Range, Criteria, Average_range)

Tambayoyi na Aiki na AVERAGEIF

Ayyukan aikin suna nuna aikin abin da ake jarraba yanayin da kuma wane irin bayanai zuwa matsakaicin lokacin da yanayin ya hadu.

Range - rukuni na sel da aikin shine don bincika.

Sha'idodi - wannan darajar an kwatanta da bayanan da ke cikin Range. Idan an sami wasa sai bayanan daidai a cikin Average_range yana da ƙimar. Ana iya shigar da bayanai na ainihi ko tantancewar tantanin halitta zuwa bayanai don wannan hujja.

Average_range (na zaɓi) - bayanai a cikin wannan kewayon Kwayoyin yana da girman lokacin da aka samu matakan tsakanin Magana da Criteria. Idan an kawar da hujjar Average_range, bayanan da suka dace a cikin Yanayin Range yana da ƙimar a maimakon.

Fara aikin aikin AVERAGEIF

Kodayake yana yiwuwa a rubuta irin aiki na AVERAGE IF a cikin tantanin halitta , mutane da yawa sun fi sauƙi don amfani da maganganun maganganu don ƙara aikin zuwa aikin aiki .

Tutorial Steps

1. Danna kan tantanin halitta E12 don yin sautin mai aiki . Wannan shi ne inda za mu shiga aikin AVERAGE IF.
2. Danna kan Rubutun shafin shafin rubutun .
3. Zaɓi Ƙari Ayyuka> Lissafi daga rubutun don buɗe jerin sauƙaƙe aikin.
4. Danna kan AVERAGE IF a cikin jerin don kawo akwatin maganganun AVERAGE IF.

Bayanan da muka shiga cikin layuka guda uku a cikin akwatin maganganu zasu haifar da muhawarar aikin AVERAGE IF.

Wadannan muhawara suna nuna aikin abin da muke gwaji don kuma wane layin bayanai zuwa matsakaici lokacin da yanayin ya hadu.

Shigar da Magana na Range

A cikin wannan koyaswar muna neman gano ƙananan tallace-tallace na shekara shekara ga yankin gabas ta Gabas.

Shawarar Range ta nuna aikin aikin AVERAGE IF wanda rukuni na sel ke nema a lokacin ƙoƙarin gano ka'idodin da aka ƙayyade - Gabas.

Tutorial Steps

1. A cikin akwatin maganganu , danna kan Ranar Range .
2. Sanya siffofin C3 zuwa C9 a cikin takardun aiki don shigar da waɗannan labaran ƙwayoyin kamar yadda za a bincika aikin.

Shigar da Sharuddan Magana

A cikin wannan misali idan bayanai a cikin kewayon C3: C12 yana da Gabas ta tsakiya to, dukkanin tallace-tallace na wannan rikodin ya kamata a yi nauyi ta hanyar aikin .

Kodayake ainihin bayanai - irin su kalmar Gabas za a iya shigar da akwatin maganganun wannan hujja mafi yawanci don ƙara bayanai zuwa cell a cikin takardun aiki sa'annan shigar da wannan tantanin halitta a cikin akwatin maganganu.

Tutorial Steps

1. Danna kan layi a cikin akwatin maganganu .
2. Danna kan tantanin halitta D12 don shigar da wannan tantanin salula. Ayyukan za su bincika tashar da aka zaba a mataki na baya don bayanai da suka dace da wannan sharudda.
3. Za a kara ma'anar bincike (East) zuwa cell D12 a mataki na karshe na koyawa.

Siffofin Siffofin Ƙara Ayyukan Sanya Ayyuka

Idan an yi la'akari da tantanin tantanin halitta, kamar D12, a matsayin Maɗaukakin Magana, aikin AVERAGE IF zai nema matakan zuwa duk wani bayanai da aka shigar a cikin tantanin ɗin a cikin takardun aiki.

Don haka bayan gano yawan tallace-tallace na ƙasashen gabas zai zama sauƙi a samo tallace-tallace na tallace-tallace ga wani yanki na tallace-tallace ta wurin canza Gabas zuwa arewa ko yamma. Aikin zai sabunta ta atomatik da kuma nuna sabon sakamakon.

Shigar da Magana na Arma'in da Ƙarin

Ƙwararren ƙarin Average_range shi ne rukuni na sel wanda aikin yake zuwa matsakaici lokacin da ya samo wani wasan a cikin Tasirin Ranar da aka gano a mataki na 5 na koyawa.

Wannan jigidar ita ce na zaɓi kuma, idan aka cire shi, nauyin Excel yana ɗauke da kwayoyin da aka ƙayyade a cikin Bayaniyar Range.

Tun da yake muna son tallace-tallace na tallace-tallace na yankin gabas ta Gabas muna amfani da bayanan a cikin jerin tallace-tallace tallace-tallace a matsayin shawara na Average_range.

Tutorial Steps

1. Danna maɓallin Line_range cikin akwatin maganganu.
2. Fassara sel E3 zuwa E9 a kan maƙallan rubutu. Idan ka'idodi da aka ƙayyade a matakin da ya gabata ya dace da kowane bayanan da ke cikin kewayon (C3 zuwa C9), aikin zai ƙididdige bayanai a cikin jinsunan da ke cikin wannan jeri na biyu.
3. Danna Ya yi don rufe akwatin maganganu kuma kammala aikin AVERAGE IF.
4. A # DIV / 0! kuskure zai bayyana a cikin cell E12 - tantanin halitta inda muka shiga aikin saboda ba mu riga muka kara bayanai zuwa filin Jagora (D12) ba.

Ƙara Matakan Bincike

Mataki na karshe a cikin koyawa shine don ƙara ma'auni da muke so aikin ya dace.

A wannan yanayin muna son samun yawan tallace-tallace na shekara-shekara don tallace-tallace a cikin yankin gabas don haka za mu ƙara kalmar gabas zuwa D12 - tantanin tantanin halitta da aka gano a cikin aikin kamar yadda ya ƙunshi jayayya .

Tutorial Steps

1. A cikin sel D12 irin ta gabas kuma latsa maɓallin shigarwa akan keyboard.
2. Amsar $ 59,641 ya kamata ya bayyana a cell E12. Tun lokacin da aka samo ma'auni na daidaitawa gabas a cikin kwayoyi guda hudu (C3 zuwa C6) lambobi a cikin sassan da ke daidai a shafi na E (E3 zuwa E6) suna da girman.
3. Lokacin da ka danna kan tantanin halitta E12, cikakken aikin
   = AVERAGEIF (C3: C9, D12, E3: E9) ya bayyana a cikin maɓallin tsari a sama da takardun aiki .
4. Don samun tallace-tallace na tallace-tallace na sauran yankunan tallace-tallace, rubuta sunan yankin, irin su Arewa a cikin cell E12 kuma latsa maɓallin shigarwa a kan keyboard.
5. Matsakaici ga wannan yanki ya kamata ya bayyana a cell E12.