Google Spreadsheets 'COUNT basa rinogona kushandiswa kuverenga mashizha ebasa rine nhamba yedata.
Nhamba idzi dzinogona kuva:
- nhamba dzakarongerwa sezvikonzero mubasa racho;
- mumasero mukati megwenga rakasarudzwa rine nhamba.
Kana nhamba yakazowedzerwa pane imwe sero mumuganhu usina chinhu kana ine mhemberero, nhamba yacho yose inongororwa patsva.
Numeri muGoogle Spreadsheets
Mukuwedzera kune imwe nhamba yepamusoro-yakadai se10, 11.547, -15, kana 0 - pane mamwe marudzi e data akachengetwa se nhamba muGoogle Spreadsheets uye ivo, saka, vanoverengerwa kana vakabatanidzwa nemashoko ekushanda.
Iyi data inosanganisira:
- mazuva uye nguva;
- mabasa ;
- fomu ;
- uye, dzimwe nguva, kukosha kweBoolean .
Syntax yeChino Function & # 39; s neArguments
Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo.
Izwi rechiito che COUNT basa nderekuti:
= COUNT (value_1, value_2, value_3, ... value_30)
value_1 - (inoda) nhamba kana hutano hunofanira kuverengwa.
value_2, value_3, ... value_30 - (optional) mamwe maitiro emadhora kana zvinyorwa zvinyorwa zvinofanira kuiswa muverengi. Nhamba yakawanda yezvinyorwa zvinobvumirwa ndeye 30.
COUNT Kushanda Muenzaniso
Mumufananidzo wepamusoro, sero rinotaura nezvemasere mapfumbamwe rinosanganiswa muhutano hunokosha hwebasa COUNT.
Nhamba dzakasiyana-siyana dzemashoko uye imwe bhokisi risina chigadzirisa inoita huwandu hwokuratidza mhando dze data dzinoita uye dzisingashande pamwe ne COUNT basa.
Nhanho dziri pasi apa zvinopinda mubasa re COUNT uye nharo yaro inokosha iri muchitokisi A10.
Kupinda COUNT Function
Google Spreadsheets haishandisi dialog boxes kuti iite nharo dzebasa sezvazvinogona kuwanikwa mu Excel. Pane kudaro, ine bhaji- yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi.
- Dzvanya pachitokisi A10 kuti uite sero rinoshandiswa - iyi ndiyo iyo migumisiro ye COUNT basa icharatidzwa;
- Tora chiyero chakaenzana (=) chinotevera nezita rebasa rekuverenga;
- Sezvaunonyora, bhokisi -self- bhokisi rinowanikwa nemazita nemazwi ekutsvaga kwemabasa anotanga netsamba C;
- Apo zita rokuti COUNT rinowanikwa mubhokisi, divha muIkiyo yeKuisa pabhobhoyo kuti uise zita rebasa uye uzarure bhatikiti rega kueshini A10;
- Simbisai masero A1 kusvika kuA9 kuti muvaise sehutano hwemhando yebasa;
- Dhinda pikicha inopinda mubhobhoyo kuti uise bhatikiti rakapoteredza " ) " uye upedze basa;
- Mhinduro 5 inofanira kuonekwa muchitokisi A10 sezvo mashanu mapfumbamwe chete mapfumbamwe ari mumakero ane nhamba;
- Paunenge uchinyora pachitsiko A10 yakapedzeswa fomu = COUNT (A1: A9) inowanikwa mubhairi yepamusoro pane pepa pepaji .
Sei Mhinduro Iripo 5
Iko mazano mumakamuri mashanu ekutanga (A1 kusvika kuA5) anotsanangurwa se data nhamba nemabasa uye anoita kuti mhinduro ye5 iri mumatare A8.
Aya maawa mashanu okutanga ane:
- nhamba-seyero A1;
- basa reSUM - cell A2;
- muumbi wokuwedzera - cell A3;
- zuva - sero A4;
- imwe nguva-sero A5.
Masero mana anotevera ane data isiri kududzirwa se nhamba ye data nhengo COUNT uye naizvozvo, isingafurwi nemabasa.
- text data - cell A6
- chirevo chinokonzera kukanganisa kukosha # DIV / 0! - cell A7
- iyo yeBoolean inokosha FALSE - cell A8
- kese isina chinhu - cell A9
Chii Chinoverengwa
Sezvambotaurwa pamusoro apa, maBoolean anokosha (TRUE kana FALSE) haasi nguva dzose anoverengwa senhamba nhengo COUNT. Kana kukosha kweBoolean kuchienzaniswa seimwe yemashoko ekushanda kunoverengwa senhamba.
Kana, sezvinowanikwa muchitokisi A8 mumufananidzo wepamusoro, zvakadaro, sero rinoreva nzvimbo yeBoolean kukosha inopinda seimwe yezvakakosha zvinokonzerwa, kukosha kweBoolean hakurevi senhamba nemabasa.
Saka, zvinhu COUNT zvinokosha:
- nhamba kana maBoolean maitiro akapinda zvakananga seimwe yemashoko ekushongedza
- mumwe sero rinotaridzirwa kune nzvimbo yenhamba yedhidhi mumushandi webasa
- ruzhinji rwemasero zvinyorwa
- a name named
Iyo inorega masero asina chinhu uye masero ezvinyorwa kune masero ane:
- text data;
- error error ;
- Boolean maonero.