Kompyuta, Mapulogalamu
"COUNTIF" mu kupambana: Zitsanzo Kufotokozera
The "COUNTIF" - mmodzi wa kaŵirikaŵiri upotrebimykh zimaonetsa amphamvu spreadsheet ntchito "kupambana" pa kampani "Microsoft". Chifukwa chiyani kuli kofunikira? Kale momveka bwino ku dzina lake. Zikuthandizani wosuta aliyense kufunsa funso "Kodi kuwerenga maselo kupambana pa muyezo winawake?" Kuti nambala yoyenera.
mfundo ntchito
Ntchito izi zimachitika mfundo ziwiri amawathandiza. The oyamba - osiyanasiyana loti awerenge chiwerengero cha maselo kukumana chikhalidwe.
The Mtsutso wachiwiri - chikhalidwe zimene angathe mu mawonekedwe a manambala kapena mawu, komanso mu mawonekedwe a zinthu.
Ife adzakonza osiyanasiyana deta ndi kuyang'ana momwe kuyang'ana kwa Yesu wonena za "COUNTIF" mu kupambana zitsanzo zochokera pa icho. Tiyeni tinene tili ndi mndandanda wa zipatso ndi ndiwo zamasamba yosungirako ndi mndandanda wa kugula awo mtengo, malonda ankamvetsa ndi tsiku kugula. Ayamba ntchito ndi matebulo kuti kupambana - ikuchitika pa fomu deta zotsatirazi:
A | The | C | D | |
1 | Zipatso / Masamba | Wogulira (kg) | Gawo (%) | Tsiku yogula |
2 | Gold maapulo | 74,5 | 28 | 05/01/2017 |
3 | Fuji maapulo | 69,8 | 50 | 05/16/2017 |
4 | nthochi | 41 | 75 | 05/04/2017 |
5 | nthochi mini | 74,5 | 42 | 05/14/2017 |
6 | maapulo Gloster | 54,2 | 34 | 05/15/2017 |
7 | nkhaka Chinese | 64 | 17 | 07/05/2017 |
8 | mungu nkhaka | 110,6 | 28 | 05/16/2017 |
9 | nkhaka unsprayed | 132,9 | 28 | 05/01/2017 |
ndi womuyenerera zofunika
The Mtsutso wachiwiri ndi chikhalidwe. Ngati tikufuna mkangano kuti mwachindunji chiwerengero kapena adiresi ya selo, mukhoza kulemba njira yoyenera. Ngati tikufuna kumanga chikhalidwe zovuta ndi fanizo la chikhalidwe, kufunafuna malemba, kapena tsiku lenileni, Mtsutso ayenera unazunguliridwa mu makoti. Basi pansipa komanso kukambirana momwe ntchito "ampersand" chizindikiro akhoza amaphatikiza ntchito zosiyanasiyana anapereka.
Zambiri zinthu kugwira ntchito
Kutchula mu gawo lathali, kuika deta kudzakuthandizani tagwirizana ndi "COUNTIF" mu kupambana. Zitsanzo zimene takambirana mu chigawo chino ndi wosavuta, koma iwo pochita, ndipo amawaona zofunika, akuyendera kuti zovuta zambiri.
Mu mawonekedwe tabular ife kuchepetsa chilinganizo, zotsatira za kukhazikitsa awo, komanso kulemba mwachidule ofotokozera ndemanga. mayankho onse zochokera deta spreadsheet analowa pamwamba, ndi kuthamanga pa tsiku 16.05.2017.
Mwachitsanzo | yankho | ndemanga |
= COUNTIF (B2: B9; 74.5) | 2 | Limavumbula malonda mmene kukopedwa pa mtengo 74,5 |
= COUNTIF (A2 A9, A2) | 1 | Ngati izi chilinganizo "Tambasula" pa mapeto pa tebulo, tiona ngati tili chibwereza Zinthu (ngati 1 - zimatengera ayi) |
= COUNTIF (D2: D9; TODAY ()) | 2 | Number maselo katundu, adzakhala alipo lero (ntchito dongosolo tsiku kompyuta a) |
= COUNTIF (C2: C9, "") | 0 | Iwo amawerengedwa chiwerengero cha maselo akusowekapo mu osiyanasiyana. Chenjezo! Ngati inu mpata mu khungu, izo si mmene munthu wopanda |
= COUNTIF (B2: B9; "<55") | 2 | Number maselo ndi kufunika osachepera 55. Mofananamo, sizikugwirizana anachita kuposa ">" osati wofanana "<>" |
= COUNTIF (B2: B9; "<55") + COUNTIF (B2: B9; "> 100") | 4 | Chiwerengero cha maselo pa mitundu ziwiri |
wildcards
Otchedwa wildcards ankagwiritsa ntchito ndi ntchito "COUNTIF" mu kupambana. Zitsanzo wildcards:
chizindikiro | mafotokozedwe |
* | Text (chiwerengero cha anthu otchulidwa) |
? | Text (nambala ya zilembo lolingana ndi chiwerengero cha zizindikiro funso). Amangogwira ntchito deta ndi mawu! Ngati khungu si kalata wosakwatiwa, nthawizonse 0 |
Full ntchito ndi matebulo mu kupambana ndi yosanthula deta kusungidwa mu iwo ndi zosatheka popanda wildcards.
Zinthu ntchito ndi makhalidwe wildcard. kaphatikizidwe ntchito
Mothandizana ndi zina kulenga zinthu ankafunila kumachitika chifukwa cha nkhani zinthu pawiri ( "kwambiri", "zosakwana", "si wolingana") ndi kufunika ntchito chizindikiro "ampersand" (k).
Mu mawonekedwe tabular, chitsanzo zovuta zambiri za ntchito chida "COUNTIF."
Mwachitsanzo | yankho | ndemanga |
= COUNTIF (A2: A9, "maapulo") | 0 | Number maselo uli ndi mawu akuti "maapulo" (choncho chisoni) ndipo onse |
= COUNTIF (A2: A9; "apulo *") | 3 | Chiwerengero cha maselo kuyamba ndi mawu akuti "apulo" ndipo mapeto iliyonse |
= COUNTIF (A2: A9; "* D *") | 3 | Chiwerengero cha maselo muli kalata "D" mu gawo lirilonse la lembalo. Nthawi zambiri ntchito kupeza ndi kuchotsa kwa zina "choyamba" kwa "ine" ndi "E" kuti "E" |
= COUNTIF (A2: A9; "??????") | 1 | Zamgululi ndi dzina la kutalika otchulidwa 6 okha |
= COUNTIF (D2: D9; "<" & (TODAY () - 10)) | 3 | Number maselo ndi tsiku kugula masiku woposera khumi zapitazo |
= COUNTIF (C2: C9; ">" & OKWANA (C2: C9)) | 3 | Number maselo ndi wofunika kwambiri poyerekezera ndi kugulitsa ankamvetsa |
Pomaliza kaye "COUNTIF" mu kupambana.
Zitsanzo zili m'nkhani ino adzakuthandizani kumvetsa zoyamba za zomangamanga ndi ma mikhalidwe imene ntchito ngati mkangano kugwira ntchito, ndipo bwinobwino ntchito pa ntchito.
Similar articles
Trending Now