Yerengani mitundu yonse ya Deta ndi Google Spreadsheets COUNTA

Mukhoza kugwiritsa ntchito Google Spreadsheets 'COUNTA ntchito kuti muwerenge malemba, manambala, malingaliro olakwika, ndi zina mwa maselo ambiri osankhidwa. Phunzirani momwe mungakhalire ndi malangizo otsogolera ndi sitepe.

01 a 04

COUNTA Function mwachidule

Pamene Google Spreadsheets ' Count Count ikuwerengera chiwerengero cha maselo m'gulu lomwe liri ndi deta yeniyeni, ntchito ya COUNTA ingagwiritsidwe ntchito kuwerengera maselo mumtundu wosiyanasiyana monga data:

• nambala;
• zolakwika - monga # DIV / 0! mu selo A3;
• masiku;
• mafomu;
• deta;
• Zofuna za Boolean (TRUE / FALSE).

Ntchitoyi imanyalanyaza zopanda kanthu kapena maselo opanda kanthu. Ngati deta ikuwonjezeredwa ku selo yopanda kanthu, ntchitoyo imangosintha zonse zomwe zikuphatikizapo Kuwonjezera.

02 a 04

COUNTA Funso la Syntax ndi Arguments

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

Chidule cha ntchito ya COUNTA ndi:

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

maselo - (oyenerera) maselo opanda kapena deta omwe ayenera kuwerengedwa.

value_2: value_30 - (zosankha) maselo owonjezera kuti akhale nawo muwerengero. Chiwerengero chazowonjezera chololedwa ndi 30.

Mtengo wotsutsana ukhoza kukhala nawo:

• maofesi aumwini pamalo a deta mu ofesi yolemba
• malingaliro osiyanasiyana a selo
• dzina lotchuka

Chitsanzo: Kuwerengera Maselo ndi COUNTA

Mu chitsanzo chowonetsedwa pa chithunzi pamwambapa, maselo osiyanasiyana kuchokera ku A2 mpaka B6 ali ndi ma data omwe amajambula m'njira zosiyanasiyana kuphatikizapo selo lopanda kanthu kuti asonyeze mitundu ya deta yomwe ingakhoze kuwerengedwa ndi COUNTA.

Maselo angapo ali ndi mayesero omwe amagwiritsidwa ntchito popanga mitundu yosiyanasiyana ya deta, monga:

• selo A3 - amagwiritsa ntchito fomu (= B2 / B3) kuti apange malingaliro olakwika # DIV / 0!
• selo A4 - amagwiritsa ntchito fanizo fomu (= B2> A6) kuti apange mtengo wa Boolean CHOONA .

03 a 04

Kulowa ku COUNTA ndi Zotsatira Zomwe Zidzakhalapo

Google Spreadsheets sagwiritsa ntchito bokosi la dialogso kuti alowe ntchito ndi zifukwa zawo zomwe zingapezeke mu Excel.

M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo. Masitepe omwe ali pansipa alowetsa ntchito ya COUNTA mu selo C2 yosonyezedwa mu chithunzi pamwambapa.

1. Dinani pa selo C2 kuti mupange selo yogwira ntchito - malo omwe zotsatira za ntchito zidzasonyezedwe;
2. Lembani chizindikiro chofanana (=) chotsatira dzina la chiwerengero cha ntchito ;
3. Pamene mukuyimira, bokosi lopangira galimoto likuwoneka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata C;
4. Pamene dzina la COUNTA likuwoneka pamwamba pa bokosi, panikizani Mphindi Muzipinda kuti mulowetse dzina la ntchito ndi kutsegula mazere (makina ozungulira) mu selo C2;
5. Onetsetsani maselo A2 mpaka B6 kuti awagwiritse ntchito monga zifukwa za ntchito;
6. Lembani fungulo lolowamo ku Enter mu khibhodi kuti muwonjezere zolemba za kutseka ndi kumaliza ntchitoyo;
7. Yankho 9 liyenera kuoneka mu selo C2 popeza maselo asanu ndi anayi okhawo khumi aliwonse ali ndi deta - selo B3 liribe kanthu;
8. Kuchotsa deta m'maselo ena ndi kuwonjezera kwa ena mu A2: B6 iyenera kuyambitsa zotsatira za ntchito kuti zisinthidwe kuti ziwonetse kusintha;
9. Mukasindikiza pa selo C3 ndondomeko yomaliza = COUNTA (A2: B6) ikuwoneka muzenera zamatabwa pamwamba pa tsamba .

04 a 04

COUNT vs. COUNTA

Kuti asonyeze kusiyana pakati pa ntchito ziwirizi, chitsanzo mu chithunzi pamwambachi chikufanizira zotsatira za COUNTA (selo C2) ndi ntchito yodziwika bwino COUNT (selo C3).

Popeza kuti COUNT imangokhala maselo omwe ali ndi chiwerengero cha nambala, imabweretsanso zotsatira za zisanu kusiyana ndi COUNTA, zomwe zimawerengera mitundu yonse ya deta ndipo zimabweretsa zotsatira za zisanu ndi zinayi.

Zindikirani:

• Masiku ndi nthawi amawerengedwa ngati nambala mu Google Spreadsheets, chifukwa chake deta mu maselo B4 ndi B5 amawerengedwa ndi ntchito zonse;
• chiwerengero cha 27 mu selo A5 chalembedwera monga momwe ziwonetsedwera ndi kusasinthika kwa deta kumbali yakumanzere ya selo - ndipo, motero, kokha kumawerengedwa ndi COUNTA.