Kwamfutocin, Software
"COUNTIF" a Excel: Misalai Description
The "COUNTIF" - daya daga cikin mafi akai-akai upotrebimykh siffofi da wani iko falle aikace-aikace "Excel" daga kamfanin "Microsoft". Me ya sa yake dole? Shi ne riga bayyana daga ta title. Yana zai taimaka wani mai amfani to tambaya "Yadda ƙidaya Kwayoyin a Excel a kan takamaiman sharudda?", Don samun dama lambar.
aiki muhawara
Wannan aiki daukan biyu da ake buƙata muhawara. A farko daga gare su - da kewayon a cikinsa wajen ƙidaya yawan Kwayoyin cewa hadu da yanayin.
Na biyu shaida - a yanayin da cewa za a iya kafa a cikin nau'i na lambobin ko kalmomi, kazalika a cikin nau'i na yanayi.
Za mu shirya wani kewayon data da kuma dubi yadda za a nemi musamman siffofin "COUNTIF" a Excel misalai dangane da shi. Bari mu ce muna da jerin 'ya'yan itatuwa da kayan lambu a cikin ajiya tare da wani jerin su saya farashi, tallace-tallace alawus da kuma sayan kwanan wata. Fara aiki tare da alluna ga Excel - yanzu shan a kan wani worksheet da wadannan bayanan:
A | A | C | D | |
1 | 'Ya'yan itãcen marmari / Kayan lambu | Saya farashi (kg) | Izni (%) | Kwanan watan sayan |
2 | Gold apples | 74,5 | 28 | 05/01/2017 |
3 | Fuji apples | 69,8 | 50 | 05/16/2017 |
4 | ayaba | 41 | 75 | 05/04/2017 |
5 | ayaba mini | 74,5 | 42 | 05/14/2017 |
6 | apples Gloster | 54,2 | 34 | 05/15/2017 |
7 | kokwamba Sin | 64 | 17 | 07/05/2017 |
8 | pollinated kokwamba | 110,6 | 28 | 05/16/2017 |
9 | kokwamba unsprayed | 132,9 | 28 | 05/01/2017 |
wani muhimmin dace
Na biyu hujjarsu a yanayin. Idan muna son wani misãli ba, to saka da lambar ko da adireshin wani cell, za ka iya rikodin da dama hanya. Idan muna so mu gina wani hadadden yanayin da kwatanta haruffa, bincika rubutu, ko da wani takamaiman rana, da shawara dole ne a kewaye a cikin quotes. Just a kasa shi kuma za ta tattauna yadda za ta amfani da "ampersand" alama za a iya hade a daban-daban ayyuka bayar.
Simple yanayi na aiki
Gabatar a baya sashe, da data sa za ta taimaka da yawa tare da "COUNTIF" a Excel. A misalai aka tattauna a wannan sashe ne quite sauki, amma su ne muhimman hakkokin, da kuma la'akari da su zama dole, kafin a ci gaba to mafi hadaddun.
A tabular form mu rage dabara, sakamakon da suka aiwatar, kazalika da rubuta wani taƙaitaccen Bayani comment. Duk amsoshin su ne bisa falle data shiga sama, da kuma gudu a kan kwanan wata 16.05.2017.
misali | amsar | comment |
= COUNTIF (B2: B9; 74.5) | 2 | Ya bayyana nawa sayarwa saya a farashin 74,5 |
= COUNTIF (A2 A9, A2) | 1 | Idan wannan dabara "mikewa" zuwa karshen tebur, za mu gani, idan muna da Kwafin Items (idan 1 - yana daukan ba) |
= COUNTIF (D2: D9; YAU ()) | 2 | Number of Kwayoyin tare da dukiya, zai zama samuwa a yau (ta amfani da kwamfuta ta tsarin kwanan) |
= COUNTIF (C2: C9, "") | 0 | Shi kirga yawan blank Kwayoyin a wani fanni. Gargadi! Idan ka sa a sarari a cikin cell, shi ba a dauke a matsayin komai |
= COUNTIF (B2: B9. "<55") | 2 | Number of Kwayoyin da darajar kasa da 55. Hakazalika, da kwatanta aka yi fiye da ">" ba daidai "<>" |
= COUNTIF (B2: B9. "<55") + COUNTIF (B2: B9; "> 100") | 4 | A total number of Kwayoyin samu a hade da yanayi biyu |
wildcards
A ake kira wildcards an yadu amfani da aiki "COUNTIF" a Excel. Misalai wildcards:
mark | description |
* | Rubutu (wani yawan haruffa) |
? | Rubutu (yawan haruffa m da adadin tambaya alamomi). Aiki kawai da rubutu data! Idan cell ba guda wasika, za ko da yaushe 0 |
Cikakken aiki tare da Tables a Excel da kuma bincika data adana a su ne kusan ba zai yiwu ba tare da yin amfani da wildcards.
Yanayi na aiki tare da wildcard haruffa. hada ayyuka
Hade da sauran siffofin don ƙirƙirar ake so yanayi na faruwa saboda mai ma'ana da yanayi fili ( "mafi", "kasa da", "ba daidai") da ake so aiki lamba "ampersand" (k).
A tabular form, la'akari da wani hadadden misali na amfani da kayan aiki "COUNTIF."
misali | amsar | comment |
= COUNTIF (A2: A9, "apples") | 0 | Number of Kwayoyin dauke da kawai da kalma "Apples" (harka m), da kuma duk |
= COUNTIF (A2: A9. "Apple *") | 3 | Yawan Kwayoyin cewa fara da kalmar "apple" da kuma wani karshen |
= COUNTIF (A2: A9. "* D *") | 3 | Yawan Kwayoyin dake dauke da harafin "d" a wani bangare na rubutu. Sau da yawa amfani da samu da kuma maye gurbin for kara "farko" to "i" da "e" to "e" |
= COUNTIF (A2: A9. "??????") | 1 | Products da sunan wani tsawon kawai 6 haruffa |
= COUNTIF (D2: D9. "<" & (YAU () - 10)) | 3 | Number of Kwayoyin tare da kwanan watan sayan fiye da goma da suka wuce kwanaki |
= COUNTIF (C2: C9; ">" & talakawan (C2: C9)) | 3 | Number of Kwayoyin da darajar mafi girma fiye da talakawan sayar da alawus |
Wannan ƙarasa dauke da "COUNTIF" a Excel.
A misalai kunshe ne a cikin wannan labarin zai taimake ka ka fahimci ka'idodi na yi da kuma haduwa da yanayin da aka yi amfani a matsayin shaida ga wani aiki, da kuma nasarar amfani da su a yi.
Similar articles
Trending Now