Kombiyuutarada, Software
"COUNTIF" ee Excel: Tusaale ahaan Description
The "COUNTIF" - mid ka mid ah inta badan upotrebimykh qoreysa codsi isbiriidhshiit awood badan "Excel" shirkadda "Microsoft". Waa maxay sababta ay lagama maarmaan tahay? Waxaa hore u caddahay ay horyaalka. Waxay kaa caawin doona wixii user si aad u weydiiso su'aal ah "Sidee loo tiriyo unugyada ee Excel on shuruudaha gaarka ah?", Si aad u hesho tirada saxda ah.
doodaha shaqo
function waxay qaadataa laba dood loo baahnaa. The ugu horeysay oo ka mid ah - kala duwan, taas oo loo tiriyo tirada unugyada in la kulmo xaaladda.
The dood labaad - xaalad kuwaasoo lagu hagaajin karo in qaab tiro ama erayada, iyo sidoo kale qaab xaaladaha.
Waxaan diyaarin doonaa kala duwan oo xogta iyo eegno sida ay u raadiyaan Tilmaamo gaar ah "COUNTIF" in tusaalooyin Excel ku salaysan waxa on. Aan niraahno waxaan leenahay liiska miraha iyo khudaarta in kaydinta liiska qiimaha iibka ay, gunnooyinka iibka iyo taariikhda iibka. Shaqo ka bilowdey la loox inay Excel - hadda qaato xaashida ah macluumaadka soo socda:
A | The | C | D | |
1 | Miraha / Khudaarta | qiimaha iibka (kg) | Allowance (%) | Taariikhda heshiiska waxiibsashada |
2 | tufaax Gold | 74,5 | 28 | 05/01/2017 |
3 | tufaax Fuji | 69,8 | 50 | 05/16/2017 |
4 | mooska | 41 | 75 | 05/04/2017 |
5 | muuska mini | 74,5 | 42 | 05/14/2017 |
6 | tufaax Gloster | 54.2 | 34 | 05/15/2017 |
7 | qajaar Chinese | 64 | 17 | 07/05/2017 |
8 | qajaar pollinated | 110,6 | 28 | 05/16/2017 |
9 | qajaar unsprayed | 132,9 | 28 | 05/01/2017 |
complement muhiim ah
Doodda ugu weyn labaad waa xaalad. Haddii aan rabno in wax xuja ah in la qeexo tirada ama cinwaanka gacanta, aad u qoraan karaan sida saxda ah. Haddii aan rabno in la dhiso xaalad adag la barbardhigo ah characters, raadi qoraal, ama taariikh gaar ah, wax xuja ah waa in lagu soo lifaaqay in xigashooyin. Just waxaa hoos sidoo kale ka wada hadli doonaan sida loo isticmaalayo "ampersand" sumadda lagu dari karaa in hawlaha kala duwan ee ay bixiyaan.
xaaladaha fudud oo shaqo
Soo bandhigay qaybta hore, xogta ay ku caawin doonaan heshiis la "COUNTIF" ee Excel. Tusaalayaasha lagaga hadlay qaybtan waa mid fudud ilaa xad, laakiin waxay yihiin asaasiga ah, iyo iyaga oo ka fiirsan loo baahan yahay, ka hor inta Socota si adag dheeraad ah.
In foomka tabular aan loo yareeyo caanaha, natiijooyinka ay fulinta, iyo sidoo kale qori a comment sharaxaadda oo kooban. Dhamaan jawaabaha ku salaysan yihiin macluumaadka isbiriidhshiit kor ku soo galay, oo ay maamulaan on 16.05.2017 taariikhda.
tusaale ahaan | jawaab | comment |
= COUNTIF (B2: B9, 74.5) | 2 | Waxay shaaca ka qaaday Ganacsi iyo inta ay le'eg iibsaday qiimo 74,5 |
= COUNTIF (A2 A9, A2) | 1 | Haddii ay taasi formula "stretch" ilaa dhamaadka horyaalka, waana arki doonaa haddii aan Items nuqul (haddii 1 - ma qaadataa) |
= COUNTIF (D2, D9, TODAY ()) | 2 | Number of unugyada mood ah, waxay noqon doontaa oo maanta la heli karo (isticmaalaya taariikhda nidaam computer ah ee) |
= COUNTIF (C2: C9, "") | 0 | Waxaa tiriyaa tirada unugyada bannaan ee kala duwan. Digniin! Haddii aad meel qol, waxa aan la tixgeliyaa sida madhan ah |
= COUNTIF (B2: B9, "<55") | 2 | Number of unugyada la qiimo ka yar 55. Sidoo kale, marka la barbardhigo la sameeyeen in ka badan ">" ma loo siman yahay "<>" |
= COUNTIF (B2: B9, "<55") + COUNTIF (B2: B9, "> 100") | 4 | Tirada guud ee unugyada helay isku dhafan ee labada shuruudaha |
wildcards
The wildcards wax-u hubkaas ayaa loo isticmaalaa la function "COUNTIF" ee Excel. Tusaalooyinka wildcards:
sumadda | description |
* | Text (tiro ka mid ah jilayaasha) |
? | Text (number of characters u dhiganta tirada calaamad su'aal). Ka shaqeeya oo kaliya xogta text! Haddii gacanta ma aha warqad keli ah, had iyo jeer doono 0 |
shaqada Full la loox Excel iyo falanqaynta xogta lagu kaydiyaa iyaga in gebi ahaanba macquul aheyn oo aan isticmaalka wildcards.
Xaaladaha shaqo la characters xulashada. isku hawlaha
Isku dhafan oo muuqaalada kale si ay u abuuraan xaalad doonayo dhacaa sabab u ah xarunta xaalado macquul ah ( "dheeraad ah", "ka yar", "ma loo siman yahay") iyo sumadda function "ampersand" la doonayo (k).
In foomka tabular, ka fiirso tusaale ahaan ka sii adag ee la isticmaalayo qalab ah "COUNTIF."
tusaale ahaan | jawaab | comment |
= COUNTIF (A2: A9, "tufaax ah") | 0 | Number of unugyada ku jiraan oo kaliya "Tufaax" erayga (case dareen la'aan), iyo dhammaan |
= COUNTIF (A2: A9, "tufaax *") | 3 | Tirada unugyada in lagu bilaabo erayga "tufaax" iyo dhammaad ma leh |
= COUNTIF (A2: A9, "* D *") | 3 | Tirada unugyada ay ku jiraan xarafka "d" ee qayb ka mid ah qoraalka. Inta badan loo isticmaalaa in la helo iyo ka bedeli waayo dheeraad ah "marka hore" in "i" iyo "e" in "e" |
= COUNTIF (A2: A9, "??????") | 1 | Products leh magaca dherer ah characters kaliya 6 |
= COUNTIF (D2, D9, "<" & (TODAY () - 10)) | 3 | Number of unugyada la bilaabo taariikhda iibsashada badan toban maalmood ka hor |
= COUNTIF (C2: C9; ">" & CELCELINTA (C2: C9)) | 3 | Number of unugyada la qiimo ka badan celceliska gunnooyinka iibinta weyn |
Tani waxay soo gebogebeeyay fikiray "COUNTIF" ee Excel.
Tusaalooyinka ku jira article idinka caawin doono inaad u fahmi lahaayeen mabaadiida aasaasiga ah ee dhismaha iyo isku darka shuruudaha loo isticmaalo sida wax xuja ah in shaqo ah, oo si guul ah ay ku dabiqi ku dhaqanka.
Similar articles
Trending Now