Verenga Nhando dzose dzeDhina neGoogle Spreadsheets COUNTA

Iwe unogona kushandisa Google Spreadsheets 'COUNTA basa kuti uverenge zvinyorwa, nhamba, kukanganisa kwenheyo, uye nezvimwe mumasero akawanda akasarudzwa. Dzidza kuti sei nhanho-nhanho mirairo iri pasi apa.

01 ye 04

COUNTA Function Overview

Kunyange zvazvo Google Spreadsheets ' Kuverenga mabasa inokwidza nhamba yemasero mune imwe nzvimbo yakasarudzwa ine chinyorwa chimwe chete che data, COUNTA basa rinogona kushandiswa kuverenga nhamba yemasero muuronga ane marudzi ese e data akadai se:

• nhamba;
• kukanganisa maitiro - akadai se # DIV / 0! muchitokisi A3;
• nguva;
• fomu;
• text data;
• Boolean maonero (TRUE / FALSE).

Basa racho rinorega kukwana masero kana pasina. Kana dhidha yakawedzerwa pane imwe sero isina chinhu basa racho rinongodzokorora huwandu hwekusanganisira kuwedzera.

02 of 04

COUNTA Function ya Syntax uye Arguments

Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .

Mutsara weCOUNTA basa ndewokuti:

= COUNTA (value_1, value_2, ... value_30)

kukosha_1 - (inoda) masero ane kana asina data inofanira kuiswa mubhuku.

kukosha2: kukosha_30 - (kusarudza) mamwe masero kuti aiswe muverengi. Nhamba yakawanda yezvinyorwa zvinobvumirwa ndeye 30.

Kukosha kwemashoko kunogona kuva:

• mumwe sero rinorondedzerwa kune nzvimbo yedhesi iri mubhidhiro remabasa
• ruzhinji rwemasero zvinyorwa
• a name named

Muenzaniso: Kuverenga Maseji neCOUNTA

Mumuenzaniso unoratidzwa mumufananidzo uri pamusoro, uwandu hwemasero kubva kuA2 kusvika kuB6 hune data yakagadziridzwa nenzira dzakasiyana-siyana pamwe chete nesero isina chinyorwa kuratidzira marudzi e data anogona kuverengwa neCOUNTA.

Masero anoverengeka ane zvigadzidzo zvinoshandiswa kuunza marudzi akasiyana-siyana emhando, zvakadai se:

• sero A3 - anoshandisa fomu (= B2 / B3) kuunza kukanganisa kwenharaunda # DIV / 0!
• sero A4 - anoshandisa mufananidzo wokufananidza (= B2> A6) kuunza kukosha kweBoolean TRUE .

03 of 04

Kupinda COUNTA neAust-Sugp

Google Spreadsheets haishandisi dialog boxes kupinda mabasa uye nharo dzavo sezvazvinogona kuwanikwa mu Excel.

Pane kudaro, ine bhaji- yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi. Matanho ari pasi apa anopinda muCOUNTA basa mumusero C2 unoratidzwa mumufananidzo uri pamusoro.

1. Dzvanya pachitokisi C2 kuti uite sero rinoshanda - nzvimbo iyo migumisiro yemabasa icharatidzwa;
2. Tora chikwangwani chakaenzana (=) chinotevera nezita renhengo yebasa;
3. Sezvaunonyora, bhokisi rinoratidza -auto rinowanikwa nemazita uye syntax yemabasa anotanga netsamba C;
4. Apo zita rokuti COUNTA rinowanikwa mukati mebhokisi, shandisa diki yeIngeni mubhobhoyo kuti uise zita rebasa uye mazera ekuzarura (bhodhi rose) muchitokisi C2;
5. Simbisai masero A2 kusvika kuB6 kuti uvaise sezvinoitwa nharo;
6. Dhinda pikicha inopinda mukibhodi kuti uwedzere mazera ekuvhara uye kupedzisa basa;
7. Mhinduro 9 inofanira kuonekwa muchitokisi C2 sezvo mapfumbamwe mapfumbamwe emasere gumi ari mumuganhu ane data - cell B3 isina chinhu;
8. Kuchenesa dhenda mune mamwe masero uye kuwedzera kune vamwe vari mumutsetse weA2: B6 inofanira kuita kuti migumisiro yebasa igadziriswe kuratidza kuchinja;
9. Paunenge uchinyora pachitsime C3 yakagadziriswa chimiro = COUNTA (A2: B6) inowanikwa mubhairi yepamusoro pane pepa pepaji .

04 we 04

COUNT vs. COUNTA

Kuti uratidze musiyano pakati pemabasa maviri, muenzaniso mufananidzo uri pamusoro apa unofanidza mhinduro dzezvose COUNTA (sero C2) uye inozivikanwa zviri nani COUNT basa (cell C3).

Sezvo COUNT inoshanda chete inoyera masero ane nhamba yedata, inodzorera chigumisiro chezvipi zvishanu kusingapesana neCOUNTA, iyo inotora marudzi ose e data mukati uye inodzorera mhinduro yepfumbamwe.

Cherechedza:

• mazuva uye nguva dzinofungidzirwa senhamba muGoogle Spreadsheets, ndicho chikonzero dhesi mumasero B4 neB5 inotarwa nemabasa ose;
• iyo nhamba 27 muchitokisi A5 yakave yakanyorwa semashoko - sezvinoratidzwa nekugadzirisa kusagadzikana kwemashoko kurutivi rworuboshwe rwesero - uye, semugumisiro, yakangoverengerwa neCOUNTA.