Indlela yokubala inani lamaseli agcwalisiwe ku-Efpelle

Lapho wenza imisebenzi ethile ngenkathi usebenza ngetafula, kuyadingeka ukubala amaseli agcwele idatha. I-Excel inikeza ithuba elinjalo lisebenzisa amathuluzi ashumekiwe. Ake sibheke ukuthi ungayikhipha kanjani inqubo ebekiwe kulolu hlelo.

Ukubala amaseli

Ohlelweni lwe-Excel, inani lamaseli agcwalisiwe lingabonakala kusetshenziswa i-counter kubha yesimo noma inqwaba yemisebenzi, ngalinye libala izinto ezigcwele uhlobo oluthile lwedatha.

Indlela 1: I-Counter kumugqa wesimo

Indlela elula yokubala amaseli aqukethe imininingwane ukusebenzisa imininingwane evela kumamitha, atholakala ohlangothini lwesokunene lwentambo yesimo ngakwesobunxele. Ngenkathi uhla lukhethwe eshidini, lapho zonke izinto zingenalutho noma zinenani elithile kuphela, le nkomba ifihliwe. I-counter ivele ngokuzenzakalela lapho amaseli amabili noma ngaphezulu angewona angewona angenalutho ahlukaniswa, bese ekhombisa inombolo yawo ngemuva kwegama elithi "ubungako".

Kepha, yize ngokuzenzakalelayo, le mitha inikwe amandla, futhi ilinde umsebenzisi ukugcizelela izinto ezithile, kwezinye izimo kungakhubazeka ngesandla. Ngemuva kwalokho umbuzo wokufakwa kwawo uyasebenza. Ukuze wenze lokhu, chofoza kwesokudla-chofoza kubha yesimo bese kuluhlu oluvula, setha umkhaza obhekene nento "yenani". Ngemuva kwalokho, i-counter izophinde iboniswe futhi.

Indlela 2: Umsebenzi wokuhlangana

Bala inani lamaseli agcwalisiwe angabalwa kusetshenziswa umsebenzi we-akhawunti. Kuhluka ngendlela eyedlule yokuvumela ukubalwa kwebanga elithile kwiseli elihlukile. Okungukuthi, ukubuka ulwazi ngalo, indawo ngeke idingeke ukuthi inikezwe njalo.

1. Khetha indawo lapho umphumela wokubala uzoboniswa khona. Chofoza isithonjana se- "Insert Function".



2. I-Master of Work Wizard iyavula. Sifuna uhlu lwento "ye-akhawunti" engenisiwe. Ngemuva kokuthi leli gama liqokonyiswe, chofoza inkinobho ethi "Kulungile".



3. Iwindi lezimpiko liqala. Izimpikiswano zalo msebenzi zixhumeka kumaseli. Isixhumanisi esiya ebangeni singabekwa ngesandla, kepha kungcono ukusetha isikhombisi kwinkambu ye- "vale1", lapho ufuna ukufaka khona idatha, bese ukhetha indawo efanelekile eshidini. Uma udinga ukubala amaseli agcwele amabanga amaningana kude kusuka komunye nomunye, izixhumanisi zebanga lesibili, lesithathu nelilandelayo kufanele lifakwe emkhakheni obizwa nge- "value2", njll. Lapho idatha yonke ifakiwe. Chofoza inkinobho ethi "KULUNGILE".



4. Lesi sici singafakwa futhi ngesandla esitokisini noma ngentambo yamafomula, sinamathelise ku-syntax elandelayo:

   = I-akhawunti (i-value1; i-value2; ...)



5. Ngemuva kokuthi ifomula ifakiwe, uhlelo endaweni ebekwe kusengaphambili lukhombisa umphumela wokubala amaseli agcwele ebangeni elicacisiwe.

Indlela 3: I-Akhawunti Yomsebenzi

Ngaphezu kwalokho, ukubala amaseli agcwele ku-Excel kusekhona umsebenzi we-akhawunti. Ngokungafani nefomula edlule, ibheka amaseli kuphela agcwele idatha yezinombolo.

1. Njengasesimweni esedlule, siqokomisa iseli lapho imininingwane izokhonjiswa khona futhi yethule imisebenzi yesethayo ngendlela efanayo. Kuyo, khetha opharetha ngegama elithi "Akhawunti". Chofoza inkinobho ethi "KULUNGILE".



2. Iwindi lezimpiko liqala. Izimpikiswano ziyefana nalapho zisebenzisa indlela edlule. Izindima zabo zibhekiselwe kumaseli. Faka izixhumanisi zamabanga eshidini lapho udinga ukubala inani lamaseli agcwele ngedatha yezinombolo. Chofoza inkinobho ethi "Kulungile".

   

   Ukwethulwa kwefomula yefomula, bambelela ku-syntax elandelayo:

   = I-akhawunti (i-value1; i-value2; ...)



3. Ngemuva kwalokho, endaweni lapho ifomula itholakala khona, inani lamaseli agcwele idatha yezinombolo lizovela.

Indlela 4: Umsebenzi we-MECKEL

Lo msebenzi ukuvumela ukubala hhayi inani lamaseli agcwele izinkulumo zamanani, kepha kuphela okufana nalo okuhambisana nesimo esithile. Isibonelo, uma ucacisa isimo esithi "> 50", kubhekwe kuphela amaseli anjalo, aqukethe inani elikhulu kune-50. Ungasetha namanani we- "" (akulingani), njll.

1. Ngemuva kokuthi iseli labelwe ukukhombisa umphumela futhi yethule imisebenzi yezemisebenzi, khetha irekhodi elithi "Ski". Chofoza inkinobho ethi "KULUNGILE".



2. Iwindi lokuphikisana livuleka. Lo msebenzi unezimpikiswano ezimbili: uhla lapho ukubalwa kweseli kwenzeka, kanye nenqubo, okungukuthi, isimo esasikhuluma ngabo ngenhla. Ensimini ethi "Range", sethula izixhumanisi zendawo ephethwe, nasensimini "yeCriterion" kufanelekile imibandela. Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".

   

   Ngokufaka okwenziwa ngesandla, ithempulethi ibukeka kanjena:

   = Amashejuli (ibanga; inqubomgomo)



3. Emva kwalokho, uhlelo lubala amaseli agcwele ebanga elizinikezele, elihambelana nesimo esibekiwe, futhi libonise endaweni echazwe esigabeni sokuqala sale ndlela.

Indlela 5: Umsebenzi wendlela yokubala

I-opharetha ebalwa yinketho ethuthukisiwe yokusebenza kwekhawunta. Kusetshenziswa lapho udinga ukucacisa isimo esingaphezu kwesisodwa samabanga ahlukene. Ungacacisa kuphela ngezimo eziyi-126.

1. Sibonisa iseli lapho umphumela uzoboniswa khona futhi uqhube imisebenzi yemisebenzi. Ifuna into "ebaliwe". Sigqagqa kancane bese ucindezela inkinobho ethi "Kulungile".



2. Ukuvulwa kwewindi lengxabano kwenzeka. Empeleni, izimpikiswano zomsebenzi ziyefana neyedlule - i- "Range" kanye "nesimo". Umehluko ukuthi amabanga kanye nezimo ezihambisanayo zingaba okuningi. Sifaka amakheli amabanga nezimo ezihambisanayo kubo, bese ucindezela inkinobho ethi "KULUNGILE".

   

   I-syntax yalesi sici imi ngale ndlela elandelayo:

   = Countal (Range_Longs1; Isimo1; Range_Longs2; Isimo2)



3. Emva kwalokho, uhlelo lokusebenza lubala amaseli agcwele amabanga acacisiwe ahambelana nezimo ezisunguliwe. Umphumela uboniswa endaweni ebekwa ngaphambi kwesikhathi.

Njengoba ubona, ukubalwa okulula kakhulu kwenani lamaseli agcwele amabanga akhethiwe kungabonakala entanjeni yesimo se-Excel. Uma udinga ukuhoxisa umphumela wendawo ehlukile eshidini, futhi nangaphezulu ukuze ukubala imibandela ethile, khona-ke kulokhu, imisebenzi ekhethekile izosiza.