Mayendedwe Opanda Vuto kapena Amtundu mu Google Spreadsheets

Momwe Mungagwiritsire Ntchito Maofesi a COUNTBLANK Mapepala a Google

Maofesi a Google, ngakhale kuti sagwiritsidwa ntchito mokwanira monga Microsoft Excel kapena LibreOffice Calc, amapereka ntchito zambiri zothandizira kusanthula deta. Imodzi mwa ntchitozi- COUNTBLANK () -yambanso chiwerengero cha maselo muzithunzi zosankhidwa zomwe ziri ndi makhalidwe osasintha.

Google Spreadsheets imathandizira zambiri zowerengera ntchito zomwe zimawerengera chiwerengero cha maselo muzithunzi zosankhidwa zomwe zili ndi deta yapadera.

Ntchito ya COUNTBLANK ntchito ndi kuwerengera chiwerengero cha maselo m'masankhidwe omwe ndi awa:

• Sakani: Maselo opanda data
• Zosasamala: Maselo okhala ndi ndondomeko yomwe imabwezera chopanda kanthu kapena mtengo wopanda pake

COUNTBLANK Syntax ya Ntchito ndi Maganizo

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Chidule cha ntchito COUNTBLANK ndi:

= COUNTBLANK (mndandanda)

Kumene kuli (kukangana kofunika) kumatanthawuza imodzi kapena maselo angapo kapena opanda deta kuti athe kuwerengedwa.

Mtsutso wambiri ukhoza kukhala nawo:

• Zithunzi za munthu payekha pa malo a deta mu tsamba la ntchito
• Mafotokozedwe osiyanasiyana a selo
• Dzina lotchulidwa

Mtsutso wosiyanasiyana uyenera kukhala gulu lophatikiza la maselo. Chifukwa COUNTBLANK salola kuti miyandamiyanda ikhale yotsatiridwa pamagulu osiyanasiyana , zochitika zingapo za ntchitoyi zikhoza kulowetsedwa muyeso limodzi kuti mupeze chiwerengero cha maselo opanda kanthu kapena opanda kanthu muwiri kapena zingapo zosagwirizana.

Kulowa ntchito COUNTBLANK

Google Spreadsheets sagwiritsira ntchito bokosi la dialogso kuti muike zifukwa za ntchito monga zingapezeke mu Excel. M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo.

1. Dinani pa selo C2 kuti mupange selo yogwira ntchito .
2. Lembani chizindikiro chofanana (=) chotsatira ndi dzina la ntchito yowerengera- ngati mukuyimira , bokosi lodzipangira lokha limapezeka ndi mayina ndi ma syntax a ntchito zomwe zimayamba ndi kalata C.
3. Pamene dzina COUNTBLANK likupezeka m'bokosilo, lowetsani ku Enter key pa kibokosilo kuti mulowetse dzina la ntchito ndi kutsegulira (kubwalo lozungulira) mu selo C5.
4. Onetsetsani maselo A2 mpaka A10 kuti muwaphatikize ngati kukangana kwa ntchito.
5. Lembani fungulo lolowamo ku Enter mu khibhodi kuti muwonjezere zolemba za kutseka ndi kumaliza ntchitoyi.
6. Yankho lidzawonekera mu selo C2.

COUNTBLANK Mafomu Osakaniza

Mmalo mwa COUNTBLANK, mukhoza kugwiritsa ntchito COUNTIF kapena COUNTIFS.

Ntchito COUNTIF imapeza chiwerengero cha maselo opanda kanthu kapena opanda kanthu m'magawo A2 mpaka A10 ndipo amapereka zotsatira zomwezo monga COUNTBLANK. Ntchito COUNTIFS ili ndi zifukwa ziwiri ndipo imawerengera chiwerengero cha zikhalidwe zomwe zikhalidwe zonsezi zatha.

Mawonekedwe awa amapereka kusintha kwakukulu mu maselo opanda kanthu kapena opanda kanthu m'mabuku amawerengedwa.