Okuqukethwe
Ukwakhiwa kwenkinga
Kukhona ibanga ledatha lapho amanye amanani aphindwa khona ngaphezu kokukodwa:
Umsebenzi ukubala inani lamanani ahlukile (angaphindi) ebangeni. Esibonelweni esingenhla, kulula ukubona ukuthi izinketho ezine kuphela ezishiwo ngempela.
Ake sicabangele izindlela ezimbalwa zokuyixazulula.
Indlela 1. Uma engekho amaseli angenalutho
Uma uqinisekile ukuthi awekho amaseli angenalutho ebangeni lokuqala ledatha, ungasebenzisa ifomula yamalungu afanayo emfushane nenhle:
Ungakhohlwa ukuyifaka njengefomula yohlu, okungukuthi cindezela ngemva kokufaka ifomula hhayi u-Enter, kodwa inhlanganisela Ctrl + Shift + Enter.
Ngobuchwepheshe, le fomula iphindaphinda kuwo wonke amaseli ochungechunge futhi ibala ingxenye ngayinye inombolo yezenzeko zayo kububanzi isebenzisa umsebenzi. COUNTIF (COUNTIF). Uma simelela lokhu njengekholomu eyengeziwe, izobukeka kanje:
Bese kubalwa izingxenyana 1/Inani lezehlakalo ku-elementi ngayinye futhi zonke zifingqwe, okuzosinika inani lezinto ezihlukile:
Indlela 2. Uma kukhona amaseli angenalutho
Uma kukhona amaseli angenalutho ebangeni, kuzodingeka ukuthi uthuthukise kancane ifomula ngokungeza isheke lamaseli angenalutho (uma kungenjalo sizothola iphutha lokuhlukanisa ngo-0 engxenyeni):
Yilokho kuphela.
- Ungazikhipha kanjani izinto eziyingqayizivele ebangeni futhi ususe izimpinda
- Ungagqamisa kanjani izimpinda ohlwini olunombala
- Ungaqhathanisa kanjani izigaba ezimbili zezimpinda
- Khipha amarekhodi ayingqayizivele etafuleni ngekholomu ethile usebenzisa isengezo se-PLEX