Okuqukethwe
Kaningi, lapho usebenza ku-Excel, udinga ukubala inani lamaseli ekhasini lomsebenzi. Lawa angase angabi nalutho noma agcwaliswe amaseli aqukethe amanani ezinombolo kuphela, futhi kwezinye izimo, okuqukethwe kwawo kufanele kuhlangabezane nemibandela ethile. Kulesi sifundo, sizobheka kabanzi imisebenzi emibili eyinhloko ye-Excel yokubala idatha − HLOLA и COUNTIF, kanye nokujwayelana nabangaziwa kakhulu - SCHETZ, COUNTBLANK и COUNTIFS.
HLOLA()
umsebenzi wezibalo HLOLA ibala inani lamaseli ohlwini lokungqubuzana oluqukethe amanani ezinombolo kuphela. Isibonelo, emfanekisweni ongezansi, sibale inani lamaseli kububanzi obuqukethe izinombolo ngokuphelele:
Esibonelweni esilandelayo, amaseli obubanzi amabili aqukethe umbhalo. Njengoba ubona, umsebenzi HLOLA uyabaziba.
Kodwa amaseli aqukethe amanani osuku nesikhathi ayacatshangelwa:
Umsebenzi HLOLA ingakwazi ukubala inani lamaseli kububanzi obungaguquki abambalwa ngesikhathi esisodwa:
Uma udinga ukubala inani lamaseli angenalutho kububanzi, ungasebenzisa umsebenzi wezibalo SCHETZ. Amaseli aqukethe umbhalo, amanani ezinombolo, idethi, isikhathi, namanani aphusile angu-TRUE noma FALSE athathwa njengangenalutho.
Rarulula inkinga ephambene, okungukuthi ubale inani lamaseli angenalutho ku-Excel, ungasebenzisa umsebenzi COUNTBLANK:
I-COUNTIF()
umsebenzi wezibalo COUNTIF ikuvumela ukubala amaseli ephepha lokusebenzela le-Excel usebenzisa izinhlobo ezahlukene zezimo. Isibonelo, ifomula engezansi ibuyisela inombolo yamaseli aqukethe amanani angemuhle:
Ifomula elandelayo ibuyisela inani lamaseli inani lawo likhulu kunokuqukethwe kweseli A4.
COUNTIF ikuvumela ukubala amaseli aqukethe amanani ombhalo. Isibonelo, ifomula elandelayo ibuyisela inombolo yamaseli aqukethe igama elithi “umbhalo” futhi ayinazwelo.
Isimo sokusebenza kwe-boolean COUNTIF ingaqukatha amakhadi asendle: * (inkanyezi) kanye ? (umbuzo). Inkanyezi imele noma iyiphi inombolo yezinhlamvu, kuyilapho uphawu lombuzo lumelela uhlamvu olulodwa olungaqondile.
Isibonelo, ukubala inani lamaseli aqukethe umbhalo oqala ngohlamvu Н (icala alizwani), ungasebenzisa ifomula elandelayo:
Uma udinga ukubala inani lamaseli aqukethe izinhlamvu ezine ngqo, sebenzisa le fomula:
Umsebenzi COUNTIF ikuvumela ukuthi usebenzise amafomula alinganayo njengesimo. Isibonelo, ukubala inani lamaseli anamanani amakhulu kunesilinganiso, ungasebenzisa le fomula elandelayo:
Uma isimo esisodwa singanele kuwe, ungakwazi njalo ukusebenzisa umsebenzi wezibalo COUNTIFS. Lo msebenzi ikuvumela ukubala amaseli ku-Excel anelisa izimo ezimbili noma ngaphezulu ngesikhathi esisodwa.
Isibonelo, ifomula elandelayo ibala amaseli amanani awo amakhulu kunoziro kodwa angaphansi kuka-50:
Umsebenzi COUNTIFS ivumela amaseli ukuthi abalwe kusetshenziswa isimo И. Uma ufuna ukubala ubuningi nesimo OR, udinga ukusebenzisa imisebenzi eminingana COUNTIF. Isibonelo, ifomula elandelayo ibala amaseli aqala ngohlamvu А kumbe ngencwadi К:
Imisebenzi ye-Excel yokubala idatha iwusizo kakhulu futhi ingaba usizo cishe kunoma yisiphi isimo. Ngethemba ukuthi lesi sifundo sikuvezele zonke izimfihlo zemisebenzi. HLOLA и COUNTIF, kanye nabasondelene nabo kakhulu - SCHETZ, COUNTBLANK и COUNTIFS. Buyela kithi kaningi. Konke okuhle kuwe nempumelelo ekufundeni i-Excel.
ngizwa!