Izinombolo zokubala kuphela ngee-Google AmaSpredishithi COUNT Umsebenzi

Umsebenzi we-Google Spreadsheets 'COUNT ungasetyenziselwa ukubala amaphepha eesebenzi aphethe idatha yesazisi.

Ezi manani zingaba:

1. manani adweliswe njengeengxabano kumsebenzi ngokwawo;
2. kwiiseli ngaphakathi kwinqanaba elikhethiweyo elinamanani.

Ukuba inani longeza emva kweseli kwibanga elingenanto okanye eliqulethe umbhalo, inani elipheleleyo lihlaziywa ngokuzenzekelayo.

Amanani kwi-Google Spreadsheets

Ukongezelela kunoma iyiphi nayiphi na inombolo engqinelanayo - njenge-10, 11.547, -15, okanye i-0 - kukho ezinye iindidi zedatha ezigcinwe njengeenombolo kwi-Google Spreadsheets kwaye ngoko ke ziya kubalelwa ukuba zibandakanyiwe neziphakamiso zomsebenzi.

Le datha ifaka:

• imihla kunye namaxesha;
• imisebenzi ;
• iifomula ;
• kwaye, ngamanye amaxesha, ixabiso leBoolean .

Umsebenzi we-COUNT kunye ne-Syntax kunye neArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano.

I-syntax ye-COUNT umsebenzi yile:

= COUNT (value_1, value_2, value_3, ... value_30)

xabiso_1 - (efunekayo) amanani okanye amaxabiso aya kubalwa.

value_2, value_3, ... value_30 - (okukhethwa kukho) ixabiso leenkcukacha ezongezelelweyo okanye iinkcukacha zeseli ukuba zifakwe kwibala. Inani eliphezulu lokungena elivunyelwe li-30.

COUNT Umsebenzi woMzekelo

Kulo mfanekiso ungentla, iiferensi zeeseli kwiiseli ezithoba zifakwe kwingxabano yexabiso le-COUNT umsebenzi.

Iintlobo ezihlukileyo zeenkcukacha zeenkcukacha eziyisixhenxe kunye neeseli ezingenanto zingenza uluhlu lubonise iintlobo zedata ezenzayo kwaye zingasebenzi kunye ne-COUNT.

Amanyathelo angaphantsi kweenkcukacha angena kwi-COUNT umsebenzi kunye nengxabano yayo yexabiso elisefayilini ye-A10.

Ukufaka i-COUNT Umsebenzi

I-Google Spreadsheets ayisebenzisi ibhokisi yencoko yababini yokufaka iingxoxo zomsebenzi njengoko zifumaneka kwi-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

1. Cofa kwi-cell A10 ukwenza i- cell esebenzayo- yiyo apho iziphumo ze-COUNT umsebenzi ziya kuboniswa;
2. Thayipha uphawu olulinganayo (=) olulandelayo lilandelwe igama lokubala komsebenzi ;
3. Njengoko uthayipha, ibhokisi ye -auto-suggestion ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta C;
4. Xa igama COUNT livela kwibhokisi, cofa iqhosha lokungena kwikhibhodi ukuze ufake igama lomsebenzi kwaye uvule ibhola ejikelezayo kwi-cell A10;
5. Phakamisa iiseli ezi-A1 ukuya ku-A9 ukuze uzibandakanye njengengxabano yesigaba somsebenzi;
6. Cinezela ukhiye wokungena kwibhodibhodi ukufaka ibakaki yokuvala " ) kwaye ugcwalise umsebenzi;
7. Impendulo yesi-5 kufuneka ibonakale kwiseli ye-A10 kuba iifestile ezintlanu kuphela ezithandathu kwibala liqulethe iinombolo;
8. Xa ucofa kwi-cell A10 ifom egcwalisiweyo = COUNT (A1: A9) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela .

Kutheni Impendulo i-5

Ixabiso kwiiseli zokuqala ezintlanu (A1 ukuya ku-A5) zitshintshwe njengedatha yenombolo ngomsebenzi kwaye zenze impendulo ye-5 kwiseli A8.

Ezi iiseli zokuqala ezinhlanu ziqulethe:

• inombolo yeseli ye-A1;
• umsebenzi we-SUM - iseli A2;
• ifomula yokongeza - iseli A3;
• i-cell cell A4;
• ixesha - i-cell A5.

Iiseli ezine ezilandelayo ziqulethe idatha engaphenduliweyo njengedatha yenombolo ye-COUNT kwaye kwaye ke ingayinakunyulwa ngumsebenzi.

• idatha yombhalo - iseli A6
• umgaqo obangela ixabiso lephutha # DIV / 0! - cell A7
• Ixabiso leBoolean FALSE - iseli A8
• i-cell engenanto engu-A9

Oko Kufumana Ukubala

Njengoko kuchazwe ngasentla, ixabiso le-Boolean (TRUE okanye FALSE) alisoloko libalwa njengamanani nge-COUNT umsebenzi. Ukuba inani leBoolean lifakwe kwisinye seengxoxo zomsebenzi kubalwa njengenombolo.

Ukuba, njengoko kuboniswe kwiseli ye-A8 kumfanekiso ongasentla, nangona kunjalo, isalathisi yesalathisi kwindawo yendawo yeBoolean ifakwe njengenye yeengxabano zexabiso , ixabiso leBoolean alibalwanga njengenombolo ngumsebenzi.

Ngoko ke, umsebenzi we-COUNT ubalwa:

• amanani okanye amaxabiso e-Boolean angeniswa ngokuthe ngqo njengenye yeengxabano zomsebenzi
• iinkcukacha zeseli nganye kwiindawo zendawo yedatha kwiphepha lokusebenzela
• uluhlu lweenkcukacha zeeseli
• uluhlu olukhethiweyo

Iyalishiya iiseli ezingenanto kunye neenkcukacha zeseli kwiiseli eziqulethe:

• idatha yombhalo;
• Iimpazamo zephutha ;
• Ixabiso leBoolean.