Makombiyuta, Software
"COUNTIF" muna Excel: Mienzaniso Description
The "COUNTIF" - mumwe inonyanyoshandiswa upotrebimykh ine simba spreadsheet kushanda "Excel" kubva kambani "Microsoft". Nei zvichikosha? Yatova pachena kubva ayo rokuremekedza. Zvichakubatsira chero anoishandisa kubvunza mubvunzo "Sei kuverenga masero ari Excel dzakananga zvinodiwa?", Kuti tiwane kodzero nhamba.
shanda zvinogutsa
basa iri kunoda zvaida nenharo maviri. Wokutanga wavo - zvakawanda iri kuverenga nhamba masero kuti asangane mamiriro.
The nharo chechipiri - chirwere chinogona kuiswa muchimiro nhamba kana mashoko, uyewo muchimiro ezvinhu.
Tichafara kugadzirira siyana mashoko uye kutarisa sei kutsvaka zvinhu chaizvo zvechiratidzo "COUNTIF" muna Excel Mienzaniso anoritsanangura. Toti tine mazita michero uye miriwo okuchengetera ane mazita avo nomutengo, rokutengesa kushivirira uye kuritenga musi. Kunotanga basa pamwe pamatafura kuna Excel - zvino kutora on pepa inotevera mashoko:
A | The | C | D | |
1 | Fruits / Vegetables | Purchase mutengo (kg) | Mvumo (%) | Date rwokutenga |
2 | Gold maapuro | 74,5 | 28 | 05/01/2017 |
3 | Fuji apple | 69,8 | 50 | 05/16/2017 |
4 | mabhanana | 41 | 75 | 05/04/2017 |
5 | mabhanana Mini | 74,5 | 42 | 05/14/2017 |
6 | maapuro Gloster | 54,2 | 34 | 05/15/2017 |
7 | gaka Chinese | 64 | 17 | 07/05/2017 |
8 | mukume gaka | 110,6 | 28 | 05/16/2017 |
9 | gaka unsprayed | 132,9 | 28 | 05/01/2017 |
rinokosha mukwanisi
The nharo rwechipiri mumugariro. Kana tichida nharo kuti kutaridzwa nhamba kana kero foni, unogona kunyora zvakarurama nzira. Kana tichida kuvaka kunzwisisa mamiriro ine fananidzo vatambi, vatsvake wenyaya, kana musi chaiwo, pfungwa inofanira akanyudzwa prices. Just pazasi zvichaita kukurukura sei kushandisa "ampersand" chiratidzo dzinogona kubatanidzwa mune akasiyana-siyana inopiwa.
Simple ezvinhu nokuti basa
Kwakamboitwa yapfuura chikamu, humboo yakatarwa kuchatibatsira kubata "COUNTIF" muna Excel. Mienzaniso muchikamu chino vari nyore, asi havana zvikuru, uye funga kuti zvakakodzera, asati vanoita kuti zvakawanda zvakaoma.
In tabular chimiro isu kuderedza yemaitiro, migumisiro Implementation yavo, uyewo nyora pfupi rinotsanangura mashoko. All mhinduro dzinobva spreadsheet Data vakapinda kumusoro, uye kumhanya musi 16.05.2017.
muenzaniso | mhinduro | komenda |
= COUNTIF (B2: B9; 74.5) | 2 | Rinozivisa nhumbizve zvakadini akatenga nemutengo 74,5 |
= COUNTIF (A2 A9, A2) | 1 | Kana ichi payakavakirwa "tatamuka" kusvikira pakuguma tafura, tichaona kana tine nouya Items (kana 1 - zvinotora hapana) |
= COUNTIF (D2: D9; TODAY ()) | 2 | Number masero pamwechete nenhumbi, vachava kuwanikwa nhasi (kushandisa kombiyuta yacho maitiro musi) |
= COUNTIF (C2: C9, "") | 0 | It haazobvumiri nhamba masero varara mune zvakawanda. Yambiro! Kana iwe musiye muchitokisi, haisi sechinhu risina chinhu |
= COUNTIF (B2: B9; "<55") | 2 | Number masero ane ukoshi asingasviki 55 Saizvozvowo, fananidzo rinoitwa kupfuura ">" haana kuenzana "<>" |
= COUNTIF (B2: B9; "<55") + COUNTIF (B2: B9; "> 100") | 4 | Uwandu masero dzawanikwa wemishonga maviri ezvinhu |
wildcards
Vanonzi wildcards zvinonzi nevakawanda kushandiswa ne mashandiro "COUNTIF" muna Excel. Mienzaniso wildcards:
maka | tsananguro |
* | Text (chero nhamba pazvinhu) |
? | Text (nhamba pazvinhu zvinoenderana nokuwanda mubvunzo mavanga). Inoshanda chete chinyorwa Data! Kana sero haisi tsamba imwe, ndichazvirumbidza nguva dzose 0 |
Full basa pamwe mabwendefa Excel uye ongorora mashoko zvakachengetwa mavari kutonetsa pasina kushandisa wildcards.
Conditions nokuti mashandiro pamwe wildcard vatambi. kubatanidza mabasa
Pamwe nemamwe zvinhu rokusika zvandinenge ezvinhu kunoitika nokuda inonzwisisika ezvinhu remubatanidzwa ( "zvakawanda", "zvishoma pane", "kwete vakaenzana") uye aida basa chiratidzo "ampersand" (k).
In tabular chimiro, funga imwe kunzwisisa muenzaniso nokushandisa mudziyo "COUNTIF."
muenzaniso | mhinduro | komenda |
= COUNTIF (A2: A9, "maapuro") | 0 | Number masero ane chete shoko "Apples" (nyaya asanzwe), uye zvose |
= COUNTIF (A2: A9; "womuapuro +") | 3 | Kuwanda masero kuti kutanga neshoko "apuro" uye chero magumo |
= COUNTIF (A2: A9; "* D *") | 3 | Kuwanda masero ane tsamba "d" chero chikamu acho. Aiwanzoshandisa kuwana uye kutsiva mamwe "kutanga" kuti "Ini" uye "e" kuti "e" |
= COUNTIF (A2: A9; "??????") | 1 | Products nezita kureba vatambi 6 chete |
= COUNTIF (D2: D9; "<" & (TODAY () - 10)) | 3 | Number masero pamwe musi kutenga mazuva anopfuura gumi adarika |
= COUNTIF (C2: C9; ">" & AVHAREJI (C2: C9)) | 3 | Number masero ane kukosha kupfuura avhareji kutengesa dzichashivirira |
Izvi yapera vaiona "COUNTIF" muna Excel.
Mienzaniso zviri munyaya ino ichakubatsira kunzwisisa zvinodiwa zvinokosha kuvakwa uye mubatanidzwa ezvinhu zvinoshandiswa sechinhu nharo kuti basa, uye zvinobudirira wodzishandisa uchidzidzira.
Similar articles
Trending Now