Amaseva e-DNS kahulumeni we-Google

Kwezinye izimo, umsebenzisi uphethwe ngokungabala inani lamagugu kukholomu, kodwa ubala inombolo yakhe. Okusho ukuthi ukuyibeka kalula, kubalulekile ukuthila ukuthi mangaki amaseli ekholomu elinikeziwe agcwele imininingwane ethile yenombolo noma yemibhalo. Ku-Excel, kunamathuluzi amaningi angaxazulula le nkinga. Cabangela ngamunye wabo ngokwehlukana.

Bheka futhi: Indlela yokubala inani lemigqa ku-Excel
Indlela yokubala inani lamaseli agcwele e-Excel

Inqubo yokubala amanani kukholomu

Ngokuya ngezinhloso zomsebenzisi, ku-Excel, kungenzeka ukubala wonke amanani kukholomu, kuphela idatha yezinombolo nalabo abahlangabezana nesimo esithile esicacisiwe. Ake sibheke indlela yokuxazulula imisebenzi ngezindlela ezehlukene.

Indlela 1: Isibonisi kubha yesimo

Le ndlela ilula futhi idinga inombolo encane yezenzo. Ikuvumela ukuthi ubale inani lamaseli aqukethe idatha yezinombolo nezombhalo. Ungakwenza lokhu ngokumane ubheke inkomba kubha yomumo.

Ukuze wenze lo msebenzi, vele ubambe inkinobho yegundane lesokunxele bese ukhetha yonke ikholomu ofuna ukubala ngayo amanani. Ngokushesha lapho ukhetho lwenziwa, ebhasini lesimo, elitholakala phansi kwefasitela, eduze kwepharamitha "Isibalo" inani lamanani aqukethwe kukholomu lizoboniswa. Ukubalwa kuzobandakanya amaseli agcwele noma iyiphi idatha (inombolo, umbhalo, usuku, njll). Izinto ezingenalutho zizobekwa indiva uma zibala.

Kwezinye izimo, isibonakaliso senani lamagugu angeke siboniswe kubha yesimo. Lokhu kusho ukuthi cishe kungenzeka kukhutshaziwe. Ukuze uyinike amandla, chofoza ngakwesokudla kwibha yomumo. Imenyu ibonakala. Kubalulekile ukuphawula ibhokisi "Isibalo". Ngemva kwalokho, inani lamaseli agcwele idatha lizoboniswa kubha yomumo.

Izinkinga zale ndlela zifakazela ukuthi umphumela owatholakali awubhaliwe noma kuphi. Okusho ukuthi ngokushesha nje uma ususa ukukhethwa, kuzophela. Ngakho-ke, uma kunesidingo, ukulungisa, kuzodingeka urekhode umphumela ophumela ngesandla. Ngaphezu kwalokho, usebenzisa le ndlela, ungabala kuphela konke okugciniwe ngamanani wamaseli futhi awukwazi ukusetha izimo zokubala.

Indlela 2: Opharetha we-ACCOUNT

Ngosizo lomqhubi COUNTnjengokwesikhashana esidlule, kungenzeka ukubala wonke amanani asekholomu. Kodwa ngokungafani nencazelo ene-indicator kubha yesimo, le ndlela inikeza ikhono lokurekhoda umphumela esakhiweni esithile seshidi.

Umsebenzi oyinhloko womsebenzi COUNTokuyinto yesigaba sezibalo ze-opharetha, kungukubalwa kwenani lamaseli angenalutho. Ngakho-ke, singakwazi ukuzivumelanisa kalula nezidingo zethu, okungukuthi, ukubala izakhi zekholomu ezigcwele idatha. I-syntax yalo msebenzi ilandelayo:

= COUNTA (value1; value2; ...)

Ngokuphelele, opharetha angaba nama-arguments angu-255 weqembu eliphelele. "Value". Lezi ziphakamiso nje zibhekisela kumaseli noma ububanzi bokubala amanani.

1. Khetha isici seshidi, lapho umphumela wokugcina uzoboniswa khona. Chofoza kusithonjana "Faka umsebenzi"elitholakala ngakwesokunxele kwebha yefomula.



2. Ngakho sibizile Umsebenzi weWebhu. Iya kusigaba "Isitatimende" bese ukhetha igama "SCHETZ". Emva kwalokho, chofoza inkinobho. "Kulungile" ezansi kule window.



3. Siya ewindini lokuphikisana lomsebenzi. COUNT. Iqukethe amasimu wokufakazela ama-arguments. Njengombalo wezingxabano, bangafinyelela amandla angu-255 amayunithi. Kodwa ukuxazulula lo msebenzi ngaphambi kwethu, insimu eyodwa yanele "Inani1". Sibeka isikhombisi kuwo futhi emva kwalokho inkinobho yesinxele yesinxele igcinwe phansi, khetha ikholomu kushidi, amanani ofuna ukuwabala. Ngemuva kokuthi izixhumanisi zekholomu zikhonjiswe ensimini, chofoza inkinobho "Kulungile" ngezansi kwewindi lezingxoxo.



4. Lolu hlelo lubala futhi lubonisa inani lazo zonke izindinganiso (kokubili izinombolo kanye nezindatshana) eziqukethwe kukholomu elilindelekile esitokisini esizikhethile esiteji sokuqala sale myalelo.

Njengoba ubona, ngokungafani nendlela eyedlule, le nketho inikeza ukubonisa umphumela esakhiweni esithile sekhasi ngokulondolozwa kwayo okungenzeka khona. Kodwa ngeshwa, umsebenzi COUNT namanje ayivumeli ukusetha izimo zokukhethwa kwamanani.

Isifundo: Umsebenzi weWebhu ku-Excel

Indlela 3: U-ACCOUNT opharetha

Ngosizo lomqhubi ACCOUNT kungenzeka ukubala izindinganiso zamanani kuphela kukholomu ekhethiwe. Iyalondoloza izindinganiso zombhalo futhi azibandakanyi kuzo inani eliphelele. Lo msebenzi uphinde ube ngowesigaba sezinkampani zokubala, njengeyaphambilini. Umsebenti wayo ukubalwa amaseli ebangeni elikhethiwe, futhi kusikathi lethu kukholomu equkethe amanani ezinombolo. I-syntax yalo msebenzi isifana nesitatimende sangaphambilini:

= COUNT (value1; value2; ...)

Njengoba ungabona, izimpikiswano ACCOUNT futhi COUNT ngokufanayo futhi limelela izixhumanisi kumaseli noma kumabanga. Umehluko ku-syntax kuphela egameni lo-opharetha ngokwayo.

1. Khetha isici kushidi lapho umphumela uzoboniswa khona. Chofoza isithonjana esivele sijwayele kithi "Faka umsebenzi".



2. Ngemuva kokuqalwa Amakhosi omsebenzi hamba kusigaba futhi "Isitatimende". Bese ukhetha igama "ACCOUNT" bese uchofoza inkinobho ethi "Kulungile".



3. Ngemuva kokuthi ifasitelana lokuphikisana le-opharetha seliqalisiwe ACCOUNTkufanele kube ensimini yakhe ukuze enze ukungena. Kuleli festile, njengasefasitela lomsebenzi wangaphambilini, izinkambu ezingafika ku-255 zingabuyekezwa, kodwa, njengesikhathi sokugcina, sidinga kuphela eyodwa yazo ebizwa ngokuthi "Inani1". Faka kule nsimu izixhumanisi zekholomu okudingeka siyisebenze ngayo. Senza ngendlela efanayo nale nqubo eyenziwe ngayo lo msebenzi. COUNT: setha isikhangiso endle bese ukhetha ikholomu yetafula. Ngemuva kokuthi ikheli lekholomu lifakwe ensimini, chofoza inkinobho "Kulungile".



4. Umphumela uzoboniswa ngokushesha esitokisini esiwachazele okuqukethwe komsebenzi. Njengoba ubona, uhlelo lubala amaseli kuphela aqukethe amanani ezinombolo. Amaseli angenalutho nezinto eziqukethe idatha yombhalo azibandakanyi ekubalweni.

Isifundo: Umsebenzi we-ACCOUNT ku-Excel

Indlela 4: I-ACCOUNT OPERATOR

Ngokungafani nezindlela zangaphambilini, usebenzisa opharetha COUNTES ikuvumela ukuthi ucacise izimo ezihambisana namagugu azoba yingxenye ekubalweni. Wonke amanye amaseli azobekwa indiva.

I-Operator COUNTES futhi kufakwe eqenjini lezibalo ze-Excel imisebenzi. Umsebenzi walo kuphela ukubala izinto ezingenalutho ebangeni, futhi esimweni sethu kukholomu ehlangabezana nesimo esinikeziwe. I-syntax yalolu opharetha ihluke ngokuphawulekayo emisebenzini emibili edlule:

= COUNTERS (ibanga; umgogodla)

Ukuphikisana "Range" iboniswa njengesixhumanisi esithile samangqamuzana amaseli, futhi kithi, kukholomu.

Ukuphikisana "Criterion" iqukethe isimo esicacisiwe. Lokhu kungaba yinani eliqondile noma umbhalo, noma inani elichazwe izinhlamvu. "okuningi" (>), "ngaphansi" (<), "akulingani" () njll.

Bala ukuthi mangaki amangqamuzana anegama "Inyama" zitholakala kukholomu yokuqala yetafula.

1. Khetha into eshadini, lapho okuzokwenziwa khona kwedatha esiphelile kuzokwenziwa. Chofoza kusithonjana "Faka umsebenzi".



2. Ngaphakathi Umsebenzi wizard yenza ushintsho esigabeni "Isitatimende"khetha igama COUNTES bese uchofoza inkinobho "Kulungile".



3. Ivuselela umsebenzi womsebenzi iwindi COUNTES. Njengoba ungabona, ifasitela inezinkambu ezimbili ezihambisana nezimpikiswano zomsebenzi.

   Ensimini "Range" ngendlela efanayo esiye sichazile ngenhla, sifaka izixhumanisi zekholomu yokuqala yetafula.

   Ensimini "Criterion" sidinga ukusetha isimo sokubala. Sibhala igama lapha "Inyama".

   Ngemuva kokuthi izilungiselelo ezingenhla zisebenze, chofoza inkinobho. "Kulungile".



4. Opharetha wenza izibalo futhi ubonisa umphumela esikrinini. Njengoba ubona, ikholomu eligqanyisiwe kumaseli angu-63 liqukethe igama "Inyama".

Ake sishintshe umsebenzi kancane. Manje bala inani lamaseli ekholomu elifanayo elingenalo igama "Inyama".

1. Khetha iseli, lapho sizobonisa khona umphumela, futhi endleleni esichazwe ekuqaleni sibiza ifasitela yeziphakamiso zomqhubi COUNTES.

   Ensimini "Range" faka izixhumanisi zekholomu yokuqala efanayo yetafula eyasetshenzwa ekuqaleni.

   Ensimini "Criterion" faka inkulumo elandelayo:

   Inyama

   Okungukuthi, le nqubo ibeka isimo sokuthi sibala zonke izakhi ezigcwele idatha ezingenalo igama "Inyama". Uphawu "" kusho ku-Excel "akulingani".

   Ngemuva kokungena kulezi zilungiselelo emawindini e-arguments chofoza inkinobho. "Kulungile".



2. Umphumela uboniswa ngokushesha esitokisini esichazwe ngaphambilini. Ubika ukuthi kunezinto ezingu-190 kukholomu eligqanyisiwe nedatha engenayo igama "Inyama".

Manje ake senze ikholomu lesithathu letafula ukubalwa kwazo zonke izindinganiso ezikhulu kunama-150.

1. Khetha iseli ukubonisa umphumela futhi wenze ushintsho ewindini lempikiswano yokusebenza COUNTES.

   Ensimini "Range" faka izixhumanisi zekholomu yesithathu yetafula lethu.

   Ensimini "Criterion" bhala isimo esilandelayo:

   >150

   Lokhu kusho ukuthi lolu hlelo luzobala kuphela lezo zakhi zekholomu eziqukethe izinombolo ezinkulu kunama-150.

   Okulandelayo, njengoba njalo, chofoza inkinobho "Kulungile".



2. Ngemva kokubala, i-Excel ibonisa umphumela kuseli elanduliwe. Njengoba ubona, ikholomu ekhethiwe iqukethe amanani angu-82 adlula kuka-150.

Ngakho, sibona ukuthi ku-Excel kunezindlela eziningi zokubala inani lamanani kukholomu. Ukukhetha ukhetho oluthile kuxhomeke emigomweni ethile yomsebenzisi. Ngakho-ke, isibonakaliso kubha yomumo sivumela kuphela ukubona inombolo yazo zonke izindinganiso kukholomu ngaphandle kokulungisa umphumela; umsebenzi COUNT inikeza ikhono lokurekhoda inani labo esitokisini esithile; opharetha ACCOUNT ibalwa kuphela izakhi eziqukethe idatha yezinombolo; futhi besebenzisa lo msebenzi COUNTES Ungasetha izimo eziyinkimbinkimbi zokubala izinto.