Ungafingqa kanjani amanani ayimpinda ku-Excel

Isifinyezo wumsebenzi wezibalo odumile ku-Excel. Ake sithi sinohlu lwezimpahla etafuleni, futhi sidinga ukuthola izindleko zazo sezizonke. Ukuze wenze lokhu, udinga ukusebenzisa umsebenzi ISUM. Noma inkampani ifuna ukunquma inani eliphelele lokusetshenziswa kukagesi isikhathi esithile. Futhi, udinga ukufingqa le datha.

Umsebenzi ISUM ingasetshenziswa ngokuzimela kuphela, kodwa futhi njengengxenye yeminye imisebenzi.

Kodwa kwezinye izimo, sidinga ukufingqa kuphela amanani ahlangabezana nemibandela ethile. Isibonelo, engeza okuqukethwe kweseli okuphindayo kuphela komunye nomunye. Kulokhu, udinga ukusebenzisa omunye wemisebenzi emibili ezochazwa kamuva.

I-summary ekhethiwe ku-Excel

I-summary ekhethiwe isinyathelo esilandelayo ngemva kokufunda ukusebenza kwe-arithmetic okujwayelekile kokwengeza amanani amaningi. Uma ufunda ukuyifunda nokuyisebenzisa, ungasondela ekubeni namandla nge-Excel. Ukuze wenze lokhu, ohlwini lwamafomula e-Excel, udinga ukuthola imisebenzi elandelayo.

Umsebenzi we-SUMIF

Ake sithi sinedathasethi enjalo.

Lona umbiko ohlinzekwe yi-warehouse yesitolo semifino. Ngokusekelwe kulolu lwazi, sidinga ukwenza okulandelayo:

1. Nquma ukuthi yimalini esele esitokweni sento ethile.
2. Bala amabhalansi e-inventory kanye nenani elifana nemithetho echazwe umsebenzisi.

Ukusebenzisa umsebenzi I-SUMMESLI singahlukanisa izincazelo ezithile futhi sizifingqe kuphela. Ake sibhale izimpikiswano zalo opharetha:

1. Ibanga. Leli iqoqo lamaseli okufanele ahlaziywe ukuze ahambisane nombandela othile. Kulobu bubanzi, angeke kube khona izinombolo kuphela, kodwa futhi namanani ombhalo.
2. Isimo. Le mpikiswano icacisa imithetho idatha ezokhethwa ngayo. Isibonelo, amanani ahambelana negama elithi "Pear" kuphela noma izinombolo ezingaphezu kuka-50.
3. uhla lokuhlanganisa. Uma kungadingeki, ungashiya le nketho. Kufanele isetshenziswe uma isethi yamanani ombhalo isetshenziswa njengobubanzi bokuhlola isimo. Kulokhu, udinga ukucacisa ububanzi obengeziwe obunedatha yezinombolo.

Ukuze ufeze umgomo wokuqala esiwubekile, udinga ukukhetha iseli lapho umphumela wezibalo uzorekhodwa khona bese ubhala ifomula elandelayo lapho: =I-SUMIF(A2:A9;“Amagilebhisi amhlophe”;B2:B9).

Umphumela uzoba inani elingu-42. Uma besinamaseli amaningana anenani elithi “Amagilebhisi Amhlophe”, ifomula izobuyisela isamba sesamba sazo zonke izindawo zalolu hlelo.

Umsebenzi we-SUM

Manje ake sizame ukubhekana nenkinga yesibili. Ubunzima bayo obuyinhloko ukuthi sinemibandela embalwa okufanele ububanzi buhlangabezane nayo. Ukuze uyixazulule, udinga ukusebenzisa umsebenzi I-SUMMESLIMN, i-syntax yayo ihlanganisa izimpikiswano ezilandelayo:

1. uhla lokuhlanganisa. Lapha le mpikiswano isho okufanayo nasesibonelweni esandulele.
2. Ububanzi besimo 1 buyisethi yamaseli okuzokhethwa kuwo lawo ahlangabezana nemibandela echazwe kumpikiswano engezansi.
3. Umbandela 1. Umthetho wempikiswano edlule. Umsebenzi uzokhetha kuphela lawo maseli ukusuka kububanzi 1 afana nesimo 1.
4. Isimo ububanzi 2, isimo 2, njalonjalo.

Ngaphezu kwalokho, izimpikiswano ziyaphindwa, udinga nje ukufaka ngokulandelana uhla ngalunye olulandelayo lwesimo kanye nombandela ngokwawo. Manje ake siqale ukuxazulula inkinga.

Ake sithi sidinga ukunquma ukuthi siyini isisindo esiphelele sama-apula ashiywe endaweni yokugcina impahla, ebiza ngaphezu kwama-ruble angu-100. Ukuze wenze lokhu, bhala ifomula elandelayo kuseli lapho umphumela wokugcina kufanele ube khona: =СУММЕСЛИМН(B2:B9;A2:A9;»яблоки*»;C2:C9;»>100″)

Ngamazwi alula, sishiya uhla lokuhlanganisa lufana nalolo lwalunjalo. Ngemva kwalokho, sibeka isimo sokuqala kanye nobubanzi baso. Ngemuva kwalokho, sibeka imfuneko yokuthi intengo kufanele ibe ngaphezu kwama-ruble ayi-100.

Qaphela inkanyezi (*) njengetemu lokusesha. Kubonisa ukuthi noma yimaphi amanye amanani angayilandela.

Ungafingqa kanjani imigqa eyimpinda etafuleni usebenzisa ithebula elihlakaniphile

Ake sithi sinetafula elinjalo. Yenziwe kusetshenziswa ithuluzi le-Smart Table. Kuyo, singabona amanani ayimpinda abekwe kumaseli ahlukene.

Ikholomu yesithathu ibala amanani alezi zinto. Ake sithi sifuna ukwazi ukuthi izobiza malini imikhiqizo ephindaphindwayo isiyonke. Yini okufanele ngiyenze? Okokuqala udinga ukukopisha yonke idatha eyimpinda kwenye ikholomu.

Ngemuva kwalokho, udinga ukuya kuthebhu ethi "Idatha" bese uchofoza inkinobho ethi "Susa Izimpinda".

Ngemva kwalokho, kuzovela ibhokisi lengxoxo lapho udinga ukuqinisekisa ukususwa kwamanani ayimpinda.

Ukuguqulwa Okunamathiselwe Okukhethekile

Ngemuva kwalokho sizosala nohlu lwalawo manani kuphela angaphindi.

Kudingeka siwakopishe bese siye kuthebhu ethi “Ekhaya”. Lapho udinga ukuvula imenyu etholakala ngaphansi kwenkinobho ethi "Faka". Ukuze wenze lokhu, chofoza umcibisholo, futhi ohlwini oluvelayo, sithola into ethi "Namathisela Okukhethekile". Ibhokisi lengxoxo elifana naleli lizovela.

Kuguqulelwa umugqa kumakholomu

Maka ibhokisi eliseduze kokuthi “Transpose” bese uchofoza okuthi KULUNGILE. Le nto ishintsha amakholomu nemigqa. Ngemva kwalokho, sibhala esitokisini ngokunganaki umsebenzi I-SUMMESLI.

Ifomula esimweni sethu izobukeka kanje.

Bese, usebenzisa umaka wokugcwalisa okuzenzakalelayo, gcwalisa amaseli asele. Ungasebenzisa futhi umsebenzi IZITHOMBE ZAMABILI ukuze ufingqe amanani ethebula. Kodwa kufanele uqale usethe isihlungi sethebula elihlakaniphile ukuze umsebenzi ubale amanani aphindayo kuphela. Ukuze wenze lokhu, chofoza isithonjana somcibisholo kunhlokweni yekholomu, bese uthikha amabhokisi aseduze kwalawo manani ofuna ukuwabonisa.

Ngemva kwalokho, siqinisekisa izenzo zethu ngokucindezela inkinobho ethi KULUNGILE. Uma sengeza enye into ezoboniswa, sizobona ukuthi inani eliphelele lizoshintsha.

Njengoba ubona, ungenza noma yimuphi umsebenzi ku-Excel ngezindlela eziningi. Ungakhetha lezo ezifanele isimo esithile noma usebenzise amathuluzi owathanda kakhulu.