Nhamba Yakasvibiswa kana kuti Masero EpaGoogle Spreadsheets

Mashandisiro Aungaita Kushanda kweGoogle SHRBANK Basa

MaSpredishiti eGoogle, kunyange zvazvo asina kunyatsoshandiswa sehurukuro yedhesi ye Microsoft Excel kana LibreOffice Calc, zvakadaro anopa zvakawanda zvakakosha zvakagadzirirwa kutsigira tsvakurudzo ye data. Chimwe chezvinhu izvi- COUNTBLANK () -dzorera nhamba yemasero muurongwa hwakasarudzwa hune maonero asina kunaka.

Google Spreadsheets inotsigira maverengi ekuverenga mabasa anoyera nhamba yemasero muhutano hwakasarudzwa ane ruzivo rwehuwandu hwemashoko.

Basa rebasa re COUNTBLANK nderekuverenga nhamba yemasero muzera rakasarudzwa izvo ndezvi:

• Empty: Makero asina data
• Zvisina kumira: Maseji ane fomu inodzorera chinhu chisina chinhu kana chisingabatsiri

COUNTBLANK Syntax yeMabasa uye Arguments

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

Izwi rechiito che COUNTBLANK basa nderekuti:

= COUNTBLANK (mararamiro)

Iko kunotarisa (inoda kuitirana) inoratidza imwe kana kuti mamwe masero ane kana kuti asina deta kuti iiswe mubhuku.

Mhirizhonga yakawanda inogona kuva ne:

• Sero rega rega rinorondedzera kune nzvimbo yedhesi iri muhwhepa
• Mhando yezvikamu zvinyorwa
• A zita rakarongwa

Nharo yakasiyana-siyana inofanira kunge iri boka rinogutsa remasero. Nokuti COUNTBLANK haibvumiri mitambo yakawanda kuti iongorwe pamakakatanwa akasiyana -siyana , zviitiko zvakasiyana zvebasa zvinogona kuiswa mune imwe nzira yekuwana nhamba yemasero asina kujeka kana asina chinhu mumatanda maviri kana akawanda asina kukodzera.

Kupinda basa re COUNTBLANK

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.

1. Dzvanya pachitokisi C2 kuti uite sero rinoshanda .
2. Tora chikamu chakafanana (=) chinotevera nezita rebasa countblank- kana iwe uchinyoresa, bhokisi rinotaridzika rinowanikwa nemazita nemazwi ekutanga emabasa anotanga netsamba C.
3. Apo zita rokuti COUNTBLANK rinowanikwa mubhokisi, divhai muIndo yeKuisa pabhobhoyo kuti uise zita rebasa uye vaberekise vakasununguka (kuburitswa kumativi ose) muchitokisi C5.
4. Simbisai masero A2 kusvika kuA10 kuti muvabatanidze senyaya yebasa rehutano.
5. Dhinda pikicha inopinda mubhobhoyo kuti uwedzere mazera ekuvhara uye kupedza basa.
6. Mhinduro yacho ichaonekwa muchitokisi C2.

COUNTBLANK Alternative Formulas

Panzvimbo pe COUNTBLANK, unogona kushandisa COUNTIF kana COUNTIFS.

Iko COUNTIF inowana nhamba yemasero asina kujeka kana asina chinhu mukati meA2 kusvika kuA10 uye anopa mhinduro imwechete se COUNTBLANK. Iko COUNTIFS basa rine mibvunzo miviri uye inongorara nhamba yemamiriro ezvinhu apo zvose zviri zviviri zvinosangana.

Aya mazano anowedzera kuchinja mune izvo zvisingabviri kana masero asina chinhu mukati mehutano anoverengwa.