I "IBhunga" function, ngokufuthi esetyenziswa Excel, bobabo criteria. Ukuba ngaba awunayo nezimaphambili ezingundoqo malunga nemisebenzi enxulumene kweli qela, uwazi inkcazelo yabo reference imiyalelo ngezantsi.
Emazantsi emasimini, umphumo iyabonakala, esele ibonisa ukuyilwa echanekileyo umsebenzi. Ngoku ke akunakwenzeka ukuba ongeze omnye meko, ngoko kwifomula kuya kufuneka ukwandisa oko kuya kuxoxwa ngazo ezi meko zimbini zilandelayo.
Option 1: Iimeko Text
Siza sihlolisise imeko xa kukho imihlathi emibini kunye neenqobo ezithile iinyanga kwimeko yethu. Kuyimfuneko ukwenza isampulu ukuze isiphumo ixabiso indlela iiseli ezininzi naleyo imeko elinikiweyo. iimeko ezimbini kudityaniswe enye indlela yokubala elula.
- Yenza inxalenye yokuqala "iBhunga" umsebenzi ngokukhankanya kwikholam yokuqala noluhlu. Umsebenzi ngokwawo ujongo eqhelekileyo: = ekuthini (A2: A25; "Ikhrayitheriya").
- Faka uphawu Ukongeza ( "+"), nto leyo eya kusebenza yokungena iimeko ezimbini.
- Ngoko nangoko emva kwayo, faka inxalenye yesibini - = ekuthini (B2: B25; "Ikhrayitheriya") - kunye cofa iqhosha igalelo.
- Ukuba kuyimfuneko, yongeza naliphi na inani yeenzuzo ngokongeza bands kunye nendlela Qinisekisa ngendlela efanayo.
Khangela isiphumo evezwayo kwisisele elinikiweyo. Ukuba Kwabakho ngesiquphe impazamo, qinisekisa ukuba ngokuchanekileyo uzigqibe lwesivakalisi komsebenzi, kwaye leseli kumqolo babe ifomathi efunekayo.
Option 2: nenani Iimeko
Kunye zisephezulu, oko ngendlela efanayo, kodwa eli xesha sihlolisise umzekelo ngakumbi ezineenkcukacha ze yingqokelela manual komsebenzi, banikwe zonke iinkcukacha.
- Emva zokupapashwa "invisi 'kwindawo yegama, wabeka uluhlu lwamanani" A1: A25 ", apho endaweni iiseli elikhankanyiweyo, ababambeleyo ukuba kuyimfuneko.
- Ngoko nangoko phezu uluhlu ngaphandle isithuba, yongeza umqondiso ";", esazisa ukuvalwa yayo.
- Emva kuyo, bhala nje inani ofuna ukubala.
- Beka uphawu "+" kwaye makongeze isahlulo sesibini olungumgubo ngendlela efanayo.
- Nje ukuba ucinezele iqhosha le-ENTER, inombolo iboniswe kwiseli eza kuba sisiphumo sesenzo sezibalo kunye neekhrayitheriya ezimbini.