Ayyukan Shafukan Google 'COUNT aiki za a iya amfani dasu don ƙididdige Kwayoyin aiki da ke dauke da bayanan lamba.
Waɗannan lambobin zasu iya zama:
- lambobi da aka jera a matsayin muhawara a cikin aikin kanta;
- a cikin sel a cikin zaɓin da aka zaɓa wanda ya ƙunshi lambobi.
Idan an ƙara lamba a cikin tantanin halitta a cikin kewayon da yake da komai ko ya ƙunshi rubutu, an ƙidaya yawan adadi ta atomatik.
Lambobi a cikin Shafukan Lissafin Google
Bugu da ƙari, duk wani nau'i mai ma'ana - irin su 10, 11.547, -15, ko 0 - akwai wasu nau'in bayanan da aka adana a matsayin lambobi a cikin Shafukan Rubutun Google kuma za a ƙidaya su idan sun haɗa da muhawarar aikin.
Wannan bayanin ya hada da:
- kwanakin da lokutan;
- ayyuka ;
- tsari ;
- kuma, a wasu lokuta, Boolean dabi'u .
Ƙungiyar COUNT & # 39; s da Arguments
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara.
Haɗin kan aikin COUNT shine:
= COUNT (value_1, value_2, value_3, ... value_30)
value_1 - (da ake buƙata) lambobi ko dabi'u don a haɗa su.
value_2, value_3, ... value_30 - (na zaɓi) ƙarin bayanan dabi'u ko ƙididdigar sel don a haɗa su cikin ƙidaya. Matsakaicin adadin shigarwar da aka yarda shi ne 30.
COUNT Ayyuka Misali
A cikin hoton da ke sama, tantanin salula na tara shine an haɗa su a cikin ƙididdiga mai kyau don aikin COUNT.
Bayanai daban-daban daban daban na bakwai da kuma salula guda ɗaya sun hada da kewayon don nuna nau'in bayanai da suke yi kuma basu aiki tare da aikin COUNT.
Matakan da ke ƙasa daki-daki yana shiga aikin COUNT da ƙimar da ke cikin tantanin halitta A10.
Shigar da aikin COUNT
Fayil ɗin Shafukan Google bazai amfani da akwatunan maganganu don shigar da muhawarar aiki kamar yadda ake samu a Excel. Maimakon haka, yana da akwati na nuna kai tsaye wanda ya tashi kamar yadda aikin aikin ya shiga cikin tantanin halitta.
- Danna kan salula A10 don sa shi tantanin halitta - wannan shine inda za a nuna sakamakon COUNT;
- Rubuta alamar daidai (=) biye da sunan aikin ƙidaya;
- Yayin da kake bugawa, akwatin zane - zane yana nuna tare da sunaye da haɗin ayyukan da suka fara da harafin C;
- Lokacin da sunan COUNT ya bayyana a cikin akwati, danna maɓallin shigarwa a kan keyboard don shigar da aikin aikin kuma bude sashin zagaye cikin sakon A10;
- Sanya siffofin A1 zuwa A9 don haɗa su a matsayin ƙwaƙwalwar kewayon aikin;
- Latsa maɓallin shigarwa a kan keyboard don shigar da takalmin rufewa " ) " kuma kammala aikin;
- Amsar 5 ya kamata ya bayyana a cell A10 tun lokacin da kawai biyar daga tara tara a cikin kewayon sun ƙunshi lambobi;
- Lokacin da ka danna kan salula A10 da aka kammala daidai = COUNT (A1: A9) ya bayyana a cikin maɓallin tsari a sama da takardun aiki .
Me yasa Amsar ta kasance 5?
Abubuwan da ke cikin sassan farko guda biyar (A1 zuwa A5) an fassara su a matsayin lambar lambobi ta hanyar aikin kuma haifar da amsar 5 a cikin cell A8.
Waɗannan farkon kwayoyi guda biyar sun ƙunshi:
- sel - cell A1;
- SUM aiki - cell A2;
- Bugu da ƙari tsari - cell A3;
- kwanan wata - cell A4;
- wani lokaci - tantanin halitta A5.
Kwayoyin hudu masu zuwa sun ƙunshi bayanan da ba a fassara su a matsayin lambar lambobin da COUNT ke aiki ba kuma yana, saboda haka, watsi da aikin.
- bayanan rubutu - cell A6
- wata ma'ana ce ta haifar da ƙimar kuskure # DIV / 0! - cell A7
- Boolean darajar FALSE - cell A8
- cell salula - A9
Abin da ke ba da shawara
Kamar yadda aka ambata a sama, Boolean dabi'u (TRUE ko FALSE) ba'a ƙidaya su a matsayin lambobi ta hanyar COUNT. Idan an ƙaddamar da adadin Boolean a matsayin daya daga cikin muhawarar aikin ta an ƙidaya shi a matsayin mai lamba.
Idan, kamar yadda aka gani a cikin salula A8 a cikin hoton da ke sama, duk da haka, tantanin tantancewar tantanin halitta akan wurin da aka ƙaddamar da adadin Boolean ya zama ɗaya daga cikin muhawarar ƙimar, ba a ƙidayar ƙimar Boolean a matsayin lambar ta wurin aikin ba.
Saboda haka, aikin COUNT yana ƙidaya:
- lambobi ko Ƙididdiga ƙididdiga da aka shiga kamar yadda ɗaya daga cikin muhawarar aikin
- tantancewar mutum yana nuna ainihin wurin da aka adana bayanai a cikin takardun aiki
- wani kewayon tantancewar salula
- wani layi mai suna
Yana watsi da kwayoyin halitta maras amfani da kuma tantance kwayoyin halitta dauke da:
- bayanan rubutu;
- kuskuren kuskure ;
- Boolean dabi'u.