COUNTIF inodzorera chirevo chemuviri kune rumwe rutivi
Iko COUNTIF inobatanidza IF iyo basa uye COUNT basa muGoogle Sheets. Uku kubatana kunokubvumira kuti uverenge nhamba yenguva yakadzama deta inowanikwa mumasarudzo akasarudzwa emasero anosangana nechimwechete, chirongwa chakasarudzwa. Heino manzwiro anoita basa:
- Iyo IF IF chikamu chebasa chinosarudza kuti dheedhi inosangana neiyo inotsanangurwa.
- Chikamu chechikamu chetatu chebasa chizere nhamba yemasero anosangana nechigarire.
Syntax yeCOUNTIF & # 39; s & Arguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemazana uye nharo . Izwi rechiito che COUNTIF basa nderekuti:
= COUNTIF (mararamiro, tsanangudzo)
Urwu ndihwo boka remasero basa riri kutsvaga. Mutsara unotarisa kana sero rakaratidzwa mumakakatanwa akaverengwa rinotorwa kana kwete. Mutsara unogona kuva:
- Nhamba.
- Sero rinotarisa nzvimbo ye data mune pepa rekushanda, saB12.
- Mutsara, akadai se100, "<= 1000" kana "<>" & B12.
- Nyora zvinyorwa kana kuti chinyorwa chinyorwa , zvakadai se "Drapes."
Kana nharo yakatarisana ine nhamba:
- Mushandisi wemuenzanisi akadai se > (mukuru kune), <= (pasi kana kuti akaenzana), kana <> (kwete kuenzana) anogona kushandiswa mumashoko uye sero rega riri muhutano rinotariswa kuti rione kana rinosangana nechirevo .
- Nokuda kwekutsvaga mararamiro akaenzana, chiratidzo chakakosha hachidi kuiswa mumashoko, uye kukosha hazvidi kuiswa mukati memashoko ekudzokorora. Semuenzaniso, zana 100 rinogona kushandiswa mukukakavadzana kwekodzero pane "= 100" kunyange zvazvo zvose zviri zviviri zvichishanda.
- Nokuda kwemashoko asina kuenzana asingatauri masero ekutengesa, mazwi ose anofanira kunge akaiswa mukati memashoko maviri ezvinyorwa , zvakadai se "<= 1000"
- Nokuda kwemashoko uchishandisa kuenzanisa operators uye seferensi dzemaferensi, zvinyorwa zveseti hazvina kuvharwa mumakiti maviri ezvinyorwa, zvakadai se "<>" & B12 kana "<=" & C12.
- Nokuda kwemashoko achishandisa kuenzanisa operators uye zvinyorwa zvitsanangudzo, muenzanisi anofananidzwa nesero rekushandisa achishandisa ampersand ( & ), iyo inyanzvi yekubvumirana mu Excel neGoogle Sheets, zvakadai se "<>" & B12 kana "<=" & C12.
Kana nharo yakatarisana ine deta deta:
- Tsananguro dzekunyora dzinofanira kunge dzakapoteredzwa mumakiti maviri ezvinyorwa, zvakadai se "drapes."
- Zvinyorwa zvinyorwa zvinogona kuva nezvayo ? uye * nhamba yemasikari kuti ifanane imwe (?) kana yakawanda (*) inonyanya kuverengwa.
- Kufananidza chaiwo? kana *, kutangira mavara aya ane tilde yakafanana ~ ~? uye ~ *.
COUNTIF Kushanda Mienzaniso
Sezvinoratidzwa mumufananidzo unoenderana nenyaya ino, COUNTIF inoshandiswa kuwana nhamba yemasero e data mumutsetse A iyo inofanirana nemitemo yakasiyana-siyana. Mitsara ye COUNTIF yemigumisiro inoratidzirwa mumutsetse B uye chimiro chairo chinoratidzwa munoramende C.
- Mitsara mitatu yekutanga yemuenzaniso ine nhamba yedhesi yeongorudzo yegadziriro yebasa uye shandisa masero A2 kusvika kuA6 kumusangano wepakati.
- Mitsetse mitatu yekupedzisira ine nhamba yedhairi yemuganhu wegakava.
Kupinda COUNT Function
MaSpredishiti eGoogle haashandisi dialog boxes kuti apinde nharo dzebasa sezvamunoona muExcel. Pane kudaro, ine bhaji-yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi. Nhanho iri pasi apa inopinda mu COUNTIF basa uye nharo dzayo dziri muchitokisi B11 chemufananidzo wemuenzaniso. Muchikamu ichi, COUNTIF inotsvaga rutivi rweA7 kusvika kuA11 kune nhamba dzisingasviki kana dzakaenzana ne100,000.
Kuisa basa COUNTIF uye nharo dzaro sezvinoratidzwa muchitokisi B11 chemufananidzo:
- Dzvanya pachitokisi B11 kuti uite sero rinoshanda . Iyi ndiyo iyo migumisiro yebasa COUNTIF icharatidzwa.
- Torai chiratidzo chakafanana ( = ) chinotevera nezita rebasa rebasa.
- Sezvaunonyora, bhokisi-self-bhokisi rinowanikwa nemazita uye syntax yemabasa anotanga netsamba C.
- Apo zita rokuti COUNTIF rinowanikwa mubhokisi, divha muIkiyo yeKuisa pabhobhoyo kuti uise zita rebasa uye uzarure bhatikiti rose muchitsi B11.
- Simbisai masero A7 kusvika kuA11 kuti muvabatanidze senyaya yebasa rehutano.
- Tora comma kuti iite separarator pakati pehutano uye nharo dzinopikisa.
- Mushure mokutengesa, nyora mashoko okuti "<=" & C12 kuti aipinde sechikonzero chekutsvaga.
- Dhinda pikicha inopinda mubhobhoyo kuti uise bhizinesi rekuvhara uye upedze basa.
- Mhinduro 4 inofanira kuonekwa muchitokisi B11 sezvo ose mana emasero ari mumakakatanwa akasiyana ane nhamba shoma kupfuura kana yakaenzana ne100,000.
- Paunenge uchitsvaga pa cell B11 , iyo yakagadzirirwa formula = nhengo (A7: A10, "<=" & C12 inowanikwa mubhairi yepamusoro pane pepaji .