Ntchito ya Google Spreadsheets 'COUNT ingagwiritsidwe ntchito kuwerengera maselo olemba ntchito omwe ali ndi chiwerengero cha nambala.
Nambala izi zingakhale:
- Nambala zikuwerengedwa ngati zotsutsana m'ntchito yokha;
- m'maselo mkati mwa mitundu yosankhidwa yomwe ili ndi manambala.
Ngati nambala yowonjezeredwa yowonjezeredwa mu selo yomwe ilibe kanthu kapena ili ndi malemba, chiwerengero chonsecho chimasinthidwa.
Nambala mu Google Spreadsheets
Kuphatikiza pa nambala iliyonse yomveka - monga 10, 11.547, -15, kapena 0 - pali mitundu ina ya deta yomwe imasungidwa ngati nambala mu Google Spreadsheets ndipo kotero, idzawerengedwa ngati ikuphatikizidwa ndi zokhudzana ndi ntchitoyo.
Deta iyi ikuphatikizapo:
- masiku ndi nthawi;
- ntchito ;
- mafomu ;
- ndipo, nthawi zina, ziyeso za Boolean .
Ntchito Yoyamba & # 39; s Syntax ndi Arguments
Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa.
Chidule cha ntchito COUNT ndi:
= COUNT (mtengo, value2, value_3, ... value_30)
value_1 - (yofunikira) chiwerengero kapena chiwerengero chomwe chiyenera kuwerengedwa.
value_2, value_3, ... value_30 - (zosankha) zowonjezereka zamtengo wapatali kapena zizindikiro za selo kuti ziphatikizidwe. Chiwerengero chazowonjezera chololedwa ndi 30.
Chitsanzo cha Ntchito COUNT
Mu chithunzi pamwambapa, mafotokozedwe a selo ku maselo asanu ndi anayi akuphatikizidwa mu ndondomeko yamtengo wa ntchito COUNT.
Dongosolo lachisanu ndi chiwiri la deta ndi selo limodzi lopanda kanthu limapanga maulendo kuti asonyeze mitundu ya deta yomwe imagwira ndi kusagwira ntchito COUNT.
Mndandanda pansipa tsatanetsatane walowa mu ntchito COUNT ndi mkangano wake wamtengo wapatali mu selo A10.
Kulowa Ntchito COUNT
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.
- Dinani pa selo A10 kuti mupange selo yogwira ntchito - izi ndi zomwe zotsatira za ntchito COUNT zidzawonetsedwa;
- Lembani chizindikiro chofanana (=) chotsatira dzina la kugwira ntchito ;
- Pamene mukuyimira, bokosi lopangira mothandizilo likuwoneka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata C;
- Pamene dzina COUNT likupezeka m'bokosilo, lowetsani ku Enter key pa kibokosilo kuti mulowetse dzina la ntchito ndi kutsegula mzere wozungulira mu selo A10;
- Onetsetsani maselo A1 mpaka A9 kuti muwaphatikize monga kukangana kwa ntchito;
- Lembani mzere wolowera ku kiyikilo kuti mulowetse mzere womaliza " ) " ndi kumaliza ntchitoyo;
- Yankho lachisanu liyenera kuoneka mu selo A10 popeza maselo asanu okha asanu ndi anayi aliwonse ali ndi nambala;
- Mukasindikiza pa selo A10 ndondomeko yomaliza = COUNT (A1: A9) ikuwoneka mu barra ya fomu pamwamba pa tsamba .
Chifukwa chiyani yankho liri 5
Makhalidwe oyambirira m'maselo asanu oyambirira (A1 mpaka A5) amatanthauzidwa ngati chiwerengero cha nambala ndi ntchito ndipo amachititsa yankho la 5 mu selo A8.
Maselo asanu oyambirira awa ali:
- selo ya A1;
- ntchito SUM - selo A2;
- Njira yowonjezera - selo A3;
- tsiku - selo A4;
- nthawi - selo A5.
Maselo anayi otsatirawa ali ndi deta zomwe sizitanthauzira ngati chiwerengero cha nambala ndi ntchito COUNT ndipo, kotero, sanyalanyazidwa ndi ntchitoyo.
- data deta - selo A6
- ndondomeko yomwe imabweretsa zolakwika # DIV / 0! - selo A7
- mtengo wa Boolean FALSE - selo A8
- selo lopanda kanthu - selo A9
Chimene Chimawerengedwa
Monga tafotokozera pamwambapa, zofunikira za Boolean (ZOONA kapena ZONSE) sizili nthawi zonse zowerengedwa ngati nambala ndi ntchito COUNT. Ngati chiwerengero cha Boolean chikuyimiridwa ngati chimodzi mwa zifukwa za ntchitoyi chiwerengedwa ngati nambala.
Ngati, monga momwe tawonera mu selo A8 mu chithunzi pamwambapa, komabe, kutanthauzira kwa selo kumalo a chiwerengero cha Boolean kunalowa ngati imodzi mwa zifukwa zamtengo wapatali , chiwerengero cha Boolean sichiwerengedwa ngati nambala ndi ntchitoyo.
Choncho, ntchito COUNT ikuwerengera:
- ziwerengero kapena zofunikira za Boolean zinalowa mwachindunji monga chimodzi mwa zifukwa za ntchito
- malingaliro amodzi pa selo la deta chiwerengero mu tsamba la ntchito
- malingaliro osiyanasiyana a selo
- dzina lotchuka
Amanyalanyaza maselo opanda kanthu ndi mafotokozedwe a maselo kumaselo okhala:
- deta;
- malingaliro olakwika ;
- Zofunika za Boolean.