Ukubala Amaseli Agcwalisiwe ku-Microsoft Excel

Uma wenza imisebenzi ethile ngenkathi usebenza netafula, kungadingeka ukuthi ubale amaseli agcwele idatha. I-Excel inikeza lesi sici ngamathuluzi akhiwe ngaphakathi. Ake sithole indlela yokwenza inqubo ecacisiwe kulolu hlelo.

Ukubala amaseli

Ku-Excel, inani lamaseli agcwele angabonakala besebenzisa ibhalansi kubha yomumo noma inamba yemisebenzi, ngayinye ebala izakhi ezigcwaliswe uhlobo oluthile lwedatha.

Indlela 1: counter counter status

Indlela elula yokubala amangqamuzana aqukethe idatha ukusebenzisa ulwazi kusuka kunqamuzana, elitholakala ngakwesokudla kwesibalo sesimo ngakwesokunxele kwezinkinobho zokushintsha izindlela zokubuka ku-Excel. Uma nje kukhona ububanzi kushidi lapho zonke izakhi zingenalutho noma eyodwa kuphela iqukethe inani elithile, le nkhomba ifihliwe. I-counter ivela ngokuzenzakalelayo uma amaseli amabili noma ngaphezulu angenalutho akhethiwe, futhi abonisa ngokushesha inombolo yabo emva kwegama "Isibalo".

Kodwa, nakuba ngokuzenzakalelayo le counter inikwe amandla, futhi ilinde kuphela ukuthi umsebenzisi akhethe izinto ezithile, kwezinye izimo zingakhutshazwa ngesandla. Khona-ke umbuzo wokufakwa kwawo ufanelekile. Ukuze wenze lokhu, chofoza ngakwesokudla kwibha yomumo nakulolu hlu oluvula, hlola ibhokisi eduze "Isibalo". Emva kwalokho, i-counter izoboniswa futhi.

Indlela 2: Umsebenzi we-ACCOUNT

Ungabala inani lamaseli agcwele usebenzisa umsebenzi we-COUNTZ. Ihlukile endleleni eyedlule ngoba ikuvumela ukuba ulungise ukubalwa kobubanzi obuthile kuseli elihlukile. Okusho ukuthi, ukubuka ulwazi kulo, isifunda ngeke sidingeke ngaso sonke isikhathi.

1. Khetha indawo lapho umphumela uzobalwa khona. Chofoza kusithonjana "Faka umsebenzi".



2. Iwindi ye-Function Wizard ivula. Sifuna into yohlu "SCHETZ". Emva kwalokhu igama ligqanyisiwe, chofoza inkinobho. "Kulungile".



3. Iwindi lempikiswano iqala. Izingqinamba zalolu msebenzi ziyizingcingo zeselula. Isixhumanisi ebangeni singabhalwa ngesandla, kodwa kungcono ukusetha isikhombisi ensimini "Inani1"lapho udinga ukufaka idatha, bese ukhetha indawo efanele eshadini. Uma kudingekile ukubala amaseli agcwalisiwe ezinkambeni eziningana ezikude komunye nomunye, khona-ke izixhumanisi zohlu lwesibili, lwesithathu nelandelayo kufanele zifakwe emasimini abizwa "Value2", "Value3" nokunye Lapho yonke idatha ingenisiwe. Sicindezela inkinobho "Kulungile".



4. Lo msebenzi ungaphinde ungene ngesandla ngomakhalekhukhwini noma emgqeni wefomula, ngokunamathela ku-syntax elandelayo:

   = COUNTA (value1; value2; ...)



5. Ngemuva kokuthi ifomula ingenisiwe, uhlelo endaweni ekhethiwe ngaphambili ibonisa umphumela wokubala amaseli agcwalisiwe ebangeni elicacisiwe.

Indlela 3: Umsebenzi we-ACCOUNT

Ngaphezu kwalokho, ngokubala amaseli agcwele e-Excel kunomsebenzi we-akhawunti. Ngokungafani nefomula langaphambilini, libheka kuphela amaseli agcwele idatha yezinombolo.

1. Njengokwesikhashana esidlule, khetha iseli lapho idatha izoboniswa futhi ngendlela efanayo isebenze iMisebenzi yeMisebenzi. Kuyo sikhetha opharetha ngegama "ACCOUNT". Sicindezela inkinobho "Kulungile".



2. Iwindi lempikiswano iqala. Amaphuzu afana nokusebenzisa indlela yangaphambilini. Indima yabo iyinkomba yezingcingo. Faka izixhumanisi zamagceke eshidi lapho ufuna ukubala inani lamaseli agcwele nge idatha yamanani. Sicindezela inkinobho "Kulungile".

   

   Ukuze ufake ngesandla ifomula, landela i-syntax:

   = COUNT (value1; value2; ...)



3. Emva kwalokho, endaweni lapho ifomula itholakala khona, inani lamaseli agcwele imininingwane yedatha izoboniswa.

Indlela 4: Umsebenzi COUNTIFIED

Lo msebenzi uvumela ukuba ungabi nje inani lamaseli agcwele izinkulumo zamanani, kodwa kuphela lezo ezihlangabezana nesimo esithile. Isibonelo, uma usetha isimo "> 50", khona-ke kuphela kulawo maseli aqukethe inani elikhulu kunama-50 azocatshangelwa. Ungasetha futhi amanani "<" (ngaphansi), "" (akulingani), njll.

1. Ngemva kokukhetha iseli ukubonisa umphumela futhi uqalise umsebenzi wizard, khetha ukungena "COUNTES". Chofoza inkinobho "Kulungile".



2. Iwindi lempikiswano ivuleka. Lo msebenzi unemibono emibili: ibanga lapho amangqamuzana abalwa khona, futhi umgomo, okungukuthi, isimo esasikhuluma ngaso ngenhla. Ensimini "Range" faka izixhumanisi endaweni ephathwayo, nasensimini "Criterion" Sifaka izimo. Emva kwalokho, chofoza inkinobho "Kulungile".

   

   Ukuze ufake okokufaka, ithempulethi ibonakala kanje:

   = COUNTERS (ibanga; umgogodla)



3. Ngemuva kwalokho, uhlelo lubala amangqamuzana agcwalisiwe ebangeni elikhethiwe elihlangabezana nesimo esibekiwe, futhi ubonise endaweni echazwe esigabeni sokuqala sale ndlela.

Indlela 5: Umsebenzi we-ACCOUNT

Umqhubi we-COUNTIFSLMN inguqulo ephakeme ye-COUNTIFIER umsebenzi. Isetshenziswe uma udinga ukucacisa isimo esingaphezu komunye womdlalo wezinhlu ezahlukene. Ungacacisa izimo ezingafika ku-126.

1. Chaza iseli lapho umphumela uzoboniswa futhi uqalise iMisebenzi Yemisebenzi. Sifuna isici kuso. SCHETESLIMN. Khetha bese uchofoza inkinobho. "Kulungile".



2. Ukuvula iwindi lempikiswano kwenzeka. Empeleni, izimpikiswano zomsebenzi zifana nalokho okwedlule - "Range" futhi "Isimo". Umehluko kuphela ukuthi kungase kube khona imigqa eminingi nezimo ezihambelanayo. Faka amakheli emigqa nemibandela ehambelanayo, bese uchofoza inkinobho "Kulungile".

   

   I-syntax yalo msebenzi ilandelayo:

   = IKHAYA (isimo_yangezimo1; isimo1; isimo_range2; isimo2; ...)



3. Emva kwalokho, isicelo sinquma amaseli agcwalisiwe wezintambo ezicacisiwe ezihlangabezana nezimo ezicacisiwe. Umphumela uboniswa endaweni ekhonjiwe ngaphambilini.

Njengoba ubona, ukubala okulula kwenombolo yamaseli agcwalisiwe ebangeni elikhethiwe kungabonakala kubha yezinga le-Excel. Uma udinga ukubonisa umphumela endaweni ehlukile eshadini, futhi ngisho nangokwengeziwe ukuze wenze ukucabanga ucabangele izimo ezithile, khona-ke imisebenzi ekhethekile izosiza.