Excel DSUM Basa reTutori

Dzidza kuti ungadzidza sei marekodhi akasarudzwa chete neDUMUM basa

Basa re DSUM nderimwe remabasa eDeccel's database . Excel database database inokubatsira paunenge uchishanda neDexcel database. A database inotora mawonekedwe efurafura huru yedata, iyo mutsara mumwe wega patafura inochengeta imwe rekodhi. Kirasi imwe neimwe mufurafura yepadheseti inochengetedza munda wakasiyana kana rudzi rwemashoko kune rekodhi imwe neimwe.

Dhiyabhorosi inoshanda kuita zvidzidzo zvekutanga, zvakadai sokuverenga, max, uye min, asi dzinobvumira mushumiri kuti ataure zvinyoreswa, kuitira kuti basa racho riitwa pane zvinyorwa chete. Zvimwe zvinyorwa zviri mu database hazvina hanya.

01 ye 02

DSUM Function Overview uye Syntax

Basa reDUMUM rinoshandiswa kuwedzera kana kuverenga mazano mumutsetse we data unosangana nemitemo yakatemwa.

DSUM Syntax uye Arguments

Mutsara weDUMUM basa nderokuti:

= DSUM (database, field, criteria)

Iro nhatu nharo dzinoda kuti:

• Dhauridzo s pecifies uwandu hwema cell references ane database. Mazita emunda anofanira kunge akabatanidzwa mukati.
• Munda inoratidza kuti ndeipi iyo korumunda kana munda inofanira kushandiswa nebasa iri kuverenga kwayo. Pinda nharo kana kuisa zita remunda mune zvinyorwa, zvakadai seRadio , kana kupinda muhombekombe nhamba, yakadai se3.
• Zvinyorwa zvinongorodza huwandu hwemasero ane maitiro anotsanangurwa nemushandisi. Urwu hunofanira kunge runosanganisira imwe zita remunda kubva kune dhesi uye imwechete imwe sero rinotarisa chirwere chinofanira kuongororwa nebasa racho.

02 of 02

Kushandisa Excel's DSUM Function Tutorial

Tarisa mufananidzo unoenderana nechikamu ichi apo iwe unoshanda kuburikidza nemadzidzo.

Izvi zvidzidzo zvinoshandisa kuwana huwandu hwehutu hunounganidzwa sezvinoratidzwa muChirongwa chekugadzira yemufananidzo wemuenzaniso. Nzira inoshandiswa kufuta deta mumuenzaniso uyu ndiwo rudzi rwemapleti.

Kuti uwane huwandu hwehutu hunounganidzwa kubva pamapapu madema uye esirivha:

1. Pinda tafura yezvakaonekwa sezvinoratidzwa mumufananidzo wemukati mumasero A1 kusvika kuE11 mune rimwe pepa rekushandura reExpcel.
2. Nyora mazita mazita mumasero A2 kusvika E2.
3. Nyora mazita mazita mumasero A13 kusvika E13. Izvi zvinoshandiswa sechikamu chegwaro reCriteria.

Kusarudza Mazano

Kuti uwane DSUM kutarisa chete dhidhi yemiti yemasira neyesirivha, pinda mumuti mazita pasi peMaple Tree zita rezita.

Kuti uwane dhiyabhorosi yemiti inopfuura miti imwe, pinda muzita rimwe nerimwe mumutsetse wakasiyana.

1. Muchitokisi A14, chengetedza zviyero, Black.
2. Muchitokisi A15, nyora zvinonzi Silver.
3. Muchitokisi D16, nyora musoro weGallons of Sap kuratidza ruzivo iro DSUM basa rinobudisa.

Kunyorera Database

Kushandisa kune zita rakarongedzwa yezvikwata zvakakura zve data zvakadai se database hazviiti kuti zvive nyore kuti tipinde nharo mubasa racho, asi rinogonawo kudzivirira kukanganisa kunokonzerwa nekusarudza nzvimbo isina kururama.

Zita rakatumidzwa dzinobatsira kana iwe ukashandisa masero emamwe masero kakawanda mukuverenga kana kana uchigadzira chati kana mairafu.

1. Simbisai masero A2 kusvika E11 mubasa rekushanda kuti musarudze maruva.
2. Dzvanya pabhokisi bhokisi pamusoro apa korome A mune pepa rekushanda.
3. Tora Mitengo muzita rebhokisi kuti ugadzire zita rakarongwa.
4. Dhinda pikicha inopinda mubhobhoyo kuti upedze kupinda.

Kuvhura dombo re DSUM Dialog

Basa rebhokisi rebhokisi rinopa nzira iri nyore yekupinda dhidhiro yega yega yebasa remashoko.

Kuzarura bhokisi rebhokisi reboka re database rekuita rinoitwa nekukanda paKinjira yeWinstreet Wizard (fx) iri pedyo nebharuti yepamusoro pane pepa pepaji.

1. Dzvanya pane cell E16 -nzvimbo iyo migumisiro yebasa icharatidzwa.
2. Dzvanya paMushandi Wemashiripiti icon kuti uuye neInter Function dialog box.
3. Tora DSUM mune Tsvaga yewindo rebasa pamusoro pebhokisi rebhokisi.
4. Dzvanya ku GO kuenda kunotsvaka basa.
5. Irobhokisi rinofanira kuwana DSUM uye inyore iyo muSarudzo yebasa .
6. Dzvanya OK kuti uzarure DSUM basa dialog box.

Kuzadzisa Arguments

1. Dzvanya paDhesi yeNhamba yebhokisi rebhokisi.
2. Tora zita rebheti Miti mumuganhu.
3. Dzvanya paMunda webhokisi rebhokisi.
4. Tora zita remunda we " Production" mumutsara. Iva nechokwadi chokuti unosanganisira zvinyorwa zvinyorwa.
5. Dzvanya paCriteria line yebhokisi rebhokisi.
6. Dragodza masero A13 kusvika kuE15 mubhidhiro rekushandisa kuti uise huwandu.
7. Dzvanya OK kuti uvhare DSUM basa dialog box uye pedza basa racho.
8. Mhinduro 152 , iyo inoratidza nhamba yemarangi emucheka wakabatanidzwa kubva mumiti yakasvibirira nesirivha, inofanira kuonekwa muchitokisi E16.
9. Paunenge uchitsvaga pane cell C7 , basa rakakwana
   = DSUM (Miti, "Kugadzira", A13: E15) inowanikwa mubhairi yepamusoro pane pepa pepaji.

Kuti uwane huwandu hwehutu hwakakonzerwa pamiti yose, unogona kushandisa basa reSUM rinogara riripo , sezvo iwe usingatsvaki kutsanangurira kuedza kugadzirisa dhidhi iyo inoshandiswa nebasa racho.

Database Database Basa

Nzira ye #Value inowanikwa kakawanda apo mazita emumunda haana kuiswa mumashoko ekudhindwa. Nokuda kwemuenzaniso uyu, iva nechokwadi chokuti munda inoshandiswa mumasero A2: E2 anowanikwa mune mazita akasiyana-siyana Miti .