Ayyukan Excel DSUM Ayyuka

Koyi yadda za a zabi adadin da aka zaɓa kawai tare da aikin DSUM

Ayyukan DSUM yana ɗaya daga cikin ayyukan ayyuka na Excel. Ayyukan bayanan Excel sun taimaka maka yayin yin aiki tare da bayanan Excel. Wani bayanan yanar gizo yawanci yana ɗaukan nauyin babban layin bayanai, inda kowane jere a cikin tebur yana adana bayanan mutum. Kowace shafi a cikin teburin layi yana ajiye filin daban ko nau'in bayanai don kowane rikodin.

Ayyukan bayanai sunyi aiki na musamman, kamar ƙidaya, max, da min, amma sun ba da damar mai amfani ya ƙayyade sharudda, don haka ana gudanar da aikin a kan takardun da aka zaɓa kawai. Sauran rubuce-rubuce a cikin bayanai suna watsi da su.

01 na 02

Siffar Ayyukan DSUM da Syntax

Ana amfani da aikin DSUM don ƙarawa ko ƙididdige dabi'u a cikin wani ɓangaren bayanan da ya dace da ka'idodi.

DSUM Syntax da Arguments

Haɗin aikin DSUM shine:

= DSUM (database, filin, ma'auni)

Tambayoyin uku da ake bukata shine:

• Bayanan yanar gizo na ƙaddamar da kewayon tantanin salula wanda ya ƙunshi bayanai. Dole ne a hada sunayen sunaye a cikin kewayon.
• Field ya nuna wane shafi ko filin ya kamata a yi amfani da shi a cikin lissafinsa. Shigar da jayayya ta hanyar buga sunan filin a quotes, kamar Radius , ko shigar da lambar shafi, kamar 3.
• Abinda aka tsara yana lissafin jeri na kwayoyin dake dauke da yanayin da mai amfani ya ƙayyade. Tsarin ya kamata ya haɗa da akalla sunan filin daya daga cikin bayanai kuma a kalla sauran tantancewar salula wanda ya nuna yanayin da za a kimantawa ta hanyar aikin.

02 na 02

Yin amfani da Ayyuka na Ayyuka na Excel ta DSUM

Duba hoto da ke bin wannan labarin yayin da kuke aiki ta hanyar koyawa.

Wannan koyaswar tana amfani da su don gano adadin sap da aka tattara kamar yadda aka jera a cikin Hotuna na samfurin misali. Ka'idodin da ake amfani dashi don tace bayanai a cikin wannan misali shine irin bishiyar maple.

Don samun adadin sap da aka samo ne kawai daga black and silver maples:

1. Shigar da teburin bayanai kamar yadda aka gani a cikin hoton misali a cikin sel A1 zuwa E11 na takarda na Excel.
2. Kwafi sunayen filin a cikin kwayoyin A2 zuwa E2.
3. Manna sunaye a cikin sel A13 zuwa E13. Ana amfani da su a matsayin ɓangare na hujja na Criteria .

Zabi Takaddun

Domin samun DSUM don duba kawai akan bayanai don bishiyoyi na fata da na azurfa, shigar da sunaye a ƙarƙashin sunan filin filin Maple .

Don samun bayanai don igiya fiye da ɗaya, shigar da kowane itace a cikin jere.

1. A cikin salula A14, rubuta ma'auni, Black.
2. A cikin salula A15, rubuta ma'auni Azurfa.
3. A cikin sakon D16, rubuta rubutun Gilashin Sap don nuna bayanin da aikin DSUM ya ba.

Namar da Database

Yin amfani da madaidaicin layi don manyan jeri na bayanai kamar database ba zai iya sauƙaƙe kawai don shigar da gardama a cikin aikin ba, amma zai iya hana kurakurai ta hanyar zaɓin ɓangaren ba daidai ba.

Jirgin da aka lakafta suna da amfani idan kun yi amfani da iri ɗaya na sel sau da yawa a cikin lissafin ko a yayin da aka tsara sigogi ko sigogi.

1. Sanya siffofin A2 zuwa E11 a cikin takardun aiki don zaɓan kewayon.
2. Danna sunan akwatin sama a sama da shafi na A a cikin takardun aiki.
3. Rubuta Bishiyoyi a cikin akwatin sunan don ƙirƙirar mai suna.
4. Latsa maɓallin shigarwa akan keyboard don kammala shigarwa.

Ana bude akwatin zane na DSUM

Maganar maganganun aiki yana samar da hanya mai sauƙi don shigar da bayanai ga kowane muhawarar aikin.

Ana buɗe akwatin maganganu don ƙungiyar bayanai na ayyuka da aka aikata ta danna kan maɓallin Wizard na Function (fx) dake kusa da maɓallin tsari a sama da takardun aiki.

1. Danna kan tantanin halitta E16- wuri wanda za'a nuna sakamakon aikin.
2. Danna maɓallin Wizard na Ɗauki don kawo akwatin kwance na Wuta .
3. Rubuta DSUM a cikin Bincike don aikin aiki a saman akwatin maganganu.
4. Danna maɓallin GO don bincika aikin.
5. Dole ne akwatin maganganu ya sami DSUM kuma ya lissafa shi a Zaɓi aikin aikin .
6. Danna Ya yi don buɗe akwatin maganganun DSUM.

Ƙarshen Magana

1. Danna kan Database Database na akwatin maganganu.
2. Rubuta adireshin mai suna Bishiyoyi cikin layi.
3. Danna kan filin filin akwatin maganganu.
4. Rubuta sunan filin " Samar" a cikin layi. Tabbatar sun hada da alamomi.
5. Danna maɓallin Lissafi na akwatin maganganu.
6. Jawo zaɓi Kwayoyin A13 zuwa E15 a cikin takardun aiki don shigar da kewayon.
7. Danna Ya yi don rufe akwatin maganganun DSUM kuma kammala aikin.
8. Amsar 152 , wadda ta nuna yawan adadin salin da aka samo daga bishiyoyin bishiyoyi na fata da na azurfa, ya kamata ya bayyana a cell E16.
9. Lokacin da ka danna kan tantanin C7 , cikakken aikin
   = DSUM (Trees, "Production", A13: E15) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.

Don samun adadin sap da aka tara don dukan bishiyoyi, zaka iya amfani da aikin SUM na yau da kullum, tun da ba ka buƙatar saka ma'auni don iyakance abin da aikin ke amfani dashi.

Kuskuren Matsala na Database

Kuskuren #Value yana faruwa sau da yawa lokacin da ba a haɗa sunayen filin a cikin bayanan bayanai ba. Don wannan misali, tabbatar da cewa sunaye sunaye a cikin sassan A2: E2 an haɗa su a cikin shafuka mai suna Trees .