Kidaye dabi'u a cikin shafi a Microsoft Excel

A wasu halaye, an yi wa mai amfani aiki ba tare da kirga jimlar abubuwan ƙimar ba a cikin shafi, amma tare da kirga adadinsu. Wannan shine, a sa a sauƙaƙe, kuna buƙatar lissafta adadin ƙwayoyin wannan ɗakin da ke cike da wasu adadi ko bayanan rubutu. A cikin Excel akwai kayan aikin da yawa waɗanda zasu iya magance wannan matsalar. Bari mu bincika kowane ɗayansu daban.

Duba kuma: Yadda za'a kirkiri yawan layuka a Excel
Yadda za'a kirkiri adadin cike sel a cikin Excel

Tsarin Kidaya

Dangane da burin mai amfani, a cikin Excel za ku iya ƙididdige dukkan dabi'u a cikin shafi, kawai lambobin bayanai ne kawai da waɗanda suka dace da yanayin da aka bayar. Bari mu kalli yadda ake warware ayyukan a hanyoyi daban-daban.

Hanyar 1: mai nuna alama a mashaya halin

Wannan hanyar ita ce mafi sauki kuma tana buƙatar mafi ƙarancin aiki. Yana ba ku damar kirga yawan adadin sel waɗanda ke ɗauke da lambobi da bayanan rubutu. Kuna iya yin wannan kawai ta hanyar duban mai nuna alama a mashaya halin.

Don kammala wannan aikin, kawai riƙe maɓallin linzamin kwamfuta na hagu ka zaɓi gaba ɗayan da kake son ƙidaya dabi'u. Da zaran an zaɓi zaɓi, a cikin mashigin matsayi, wanda yake a ƙasan taga, kusa da sigogi "Yawan" Za'a nuna adadin dabi'un da ke cikin shafin. Kwayoyin da aka cika tare da kowane bayanan (lambobi, rubutu, kwanan wata, da sauransu) za su shiga cikin lissafin. Abubuwan da ba za su bar komai ba za a yi watsi dasu yayin kirgawa.

A wasu halayen, mai nuna adadin ƙimar ƙila ba za a nuna shi a masarar matsayin ba. Wannan yana nuna cewa da alama akwai rauni. Don ba shi damar, danna-dama a kan masalin hali. Wani menu zai bayyana. A ciki akwai buƙatar bincika akwatin kusa da "Yawan". Bayan wannan, yawan ƙwayoyin da ke cike da bayanai za a nuna su a sandar matsayin.

Rashin dacewar wannan hanyar hada da cewa sakamakon ba a gyara komai a koina ba. Wato, da zaran ka cire zabin, zai bace. Sabili da haka, idan ya cancanta, gyara shi, zaku yi rikodin sakamakon da hannu. Bugu da kari, ta amfani da wannan hanyar, yana yiwuwa a kirga dukkan sel wadanda aka cika su da dabi'u kuma bashi yiwuwa a tsara yanayin kirga.

Hanyar 2: Ma'aikaci na ACCOUNTS

Yin amfani da afareta LATSAkamar yadda yake a baya, yana yiwuwa a kirga duk dabi'un da ke cikin shafi. Amma sabanin zaɓi tare da nuna alama a cikin masalin matsayin, wannan hanyar tana ba da ikon yin rikodin sakamakon a cikin wani ɓangaren daban na takardar.

Babban maƙasudin aikin LATSA, wanda ya kasance nau'in ƙididdiga na masu aiki, kawai yana ƙididdige yawan adadin ƙwayoyin marasa komai. Sabili da haka, zamu iya daidaita shi zuwa bukatunmu, wato, ƙidaya abubuwan abubuwan shafi cike da bayanai. Ginin kalma na wannan aikin kamar haka:

= COUNT (darajar1; darajar2; ...)

A cikin duka, mai aiki zai iya samun hujjoji 255 na janar rukuni "Darajar". Muhawara dai kawai nassoshi ne ga sel ko kuma kewayon da kake son ƙididdigar darajar ku.

1. Zaɓi ɓangaren takardar abin da za a nuna sakamakon ƙarshe. Danna alamar "Saka aikin"wanda yake gefen hagu na dabarar dabara.



2. Kamar haka muke kira Mayan fasalin. Je zuwa rukuni "Na lissafi" kuma zaɓi sunan BATSA. Bayan haka, danna maɓallin "Ok" a kasan wannan taga.



3. Muna zuwa taga muhawara na aiki LATSA. Ya ƙunshi filayen shigarwar don muhawara. Kamar adadin muhawara, suna iya kaiwa raka'a 255. Amma don warware aikin da aka sanya a gabanmu, filin daya ya isa "Darajar1". Mun sanya siginan kwamfuta a ciki kuma bayan wannan, tare da maɓallin linzamin kwamfuta na hagu, zaɓi maballin akan takardar wanda ƙididdiga kuke son yin lissafin. Bayan an nuna alamun daidaitawa a fagen, danna maɓallin "Ok" a kasan taga muhawara.



4. Shirin yana ƙididdigewa kuma yana nunawa a cikin tantanin da muka zaba a matakin farko na wannan umarnin, adadin duk dabi'u (duka adadi da rubutu) wanda ke kunshe a cikin maƙallan manufa.

Kamar yadda kake gani, sabanin hanyar da ta gabata, wannan zabin yana ba da damar nuna sakamakon a cikin wani takamaiman ɓangaren takardar tare da damar ceton ta. Amma rashin alheri, aikin LATSA duk da haka, baya bada damar ƙayyade yanayin halayen dabi'u.

Darasi: Kayan aiki na kwarai

Hanyar 3: Ma'aikaci na ACCOUNT

Yin amfani da afareta LABARI lambobin lambobi kawai a cikin akwatin da aka zaɓa za'a iya kirgawa. Yana watsi da ƙimar rubutu kuma baya haɗa su a cikin duka. Wannan aikin shima mallakar rukuni ne na manajan ƙididdiga, kamar na baya. Aikinta shine ƙididdige ƙwayoyin sel a cikin zaɓaɓɓen zaɓi, kuma a cikin yanayinmu, a cikin shafi wanda ya ƙunshi ƙimar lamba. Gwanin wannan aikin kusan daidai yake da bayanin da ya gabata:

= COUNT (darajar1; darajar2; ...)

Kamar yadda kake gani, muhawara ta LABARI da LATSA iri ɗaya ne kuma suna wakiltar nassoshi ko sel. Bambanci a cikin yanayin sanya sunan yana aiki ne kawai da sunan mai aiki da kansa.

1. Zaɓi kashi a takardar a inda za a nuna sakamakon. Danna alamar da muka riga muka sani "Saka aikin".



2. Bayan jefawa Wizards na Aiki matsa zuwa rukuni kuma "Na lissafi". Sannan zaɓi sunan "LATSA" kuma danna maballin "Ok".



3. Bayan an fara tattaunawar muhawara ta mai aiki LABARI, yakamata a shigo cikin filin. A cikin wannan taga, kamar yadda a cikin taga na aikin da ya gabata, har ila yau ana iya gabatar da filaye 255, amma, kamar na ƙarshe, muna buƙatar ɗayansu kawai da ake kira "Darajar1". Shiga cikin wannan filin aikin da muke buƙatar aiwatar da aikin. Munyi wannan duk yadda muka aikata wannan ka'ida don aikin LATSA: saita siginan kwamfuta a cikin filin kuma zaɓi shafi teburin. Bayan an shigar da adireshin shafi a fagen, danna maballin "Ok".



4. Sakamakon za a nuna shi nan da nan a cikin tantanin halitta da muka ayyana don abubuwan aikin. Kamar yadda kake gani, shirin ya kirkiri sel ne kawai wadanda suke dauke da dabi'un lamba. Ba a haɗa ƙwayoyin sel da abubuwa masu ɗauke da bayanan rubutu cikin ƙidaya ba.

Darasi: Kidaya aiki a cikin Excel

Hanyar 4: mai ba da izini COUNTIF

Ba kamar hanyoyin da suka gabata ba, amfani da ma'aikaci TAMBAYA ba ku damar saita yanayin da zai dace da dabi'u waɗanda zasu shiga cikin lissafin. Duk sauran kwayoyin halitta za a yi watsi da su.

Mai aiki TAMBAYA Hakanan an yi su a matsayin ƙungiyar ƙididdiga ta ayyukan Excel. Aikinta kawai shine ƙididdige abubuwa marasa ma'ana a cikin kewayon, kuma a cikin yanayinmu, a cikin shafi wanda ya dace da yanayin da aka bayar. Gaskiyar magana na wannan ma'aikatar ta bambanta da kyau a cikin ayyukan biyu da suka gabata:

= COUNTIF (kewa; rarrabuwa)

Hujja "Range" An wakilta shi azaman hanyar haɗi zuwa takamaiman tsararruwar sel, kuma a cikin yanayinmu, zuwa shafi.

Hujja "Sharhin" yana dauke da yanayin da aka tsara. Wannan na iya zama daidai lambar ƙidaya ko darajar rubutu, ko darajar da alamomi suka ayyana ƙari (>), kasa (<), ba daidai ba (), da sauransu.

Bari mu ƙididdige adadin ƙwayoyin da sunan Nama suna a cikin farkon shafi na tebur.

1. Zaɓi kashi a kan takardar inda kayan aikin da aka ƙare za a yi. Danna alamar "Saka aikin".



2. A Mayen aiki yi canji zuwa rukuni "Na lissafi", zaɓi sunan TAMBAYA kuma danna maballin "Ok".



3. An kunna aikin muhawara na ayyuka TAMBAYA. Kamar yadda kake gani, taga yana da filaye guda biyu waɗanda suka dace da muhawara na aikin.

   A fagen "Range" kamar yadda muka bayyana fiye da sau ɗaya, mun shigar da daidaitawar shafin farko na tebur.

   A fagen "Sharhin" muna buƙatar saita yanayin ƙidaya. Shigar da kalmar a can Nama.

   Bayan an gama saitunan da ke sama, danna maballin "Ok".



4. Mai aiki yana yin lissafin kuma yana nuna sakamako a allon. Kamar yadda kake gani, a cikin shafi da aka zaɓa a cikin sel 63 yana ɗauke da kalmar Nama.

Bari mu canza aikin kaɗan. Yanzu bari mu kirga adadin sel a cikin sashin layi guda ɗaya waɗanda basu da kalmar Nama.

1. Muna zaɓar tantanin halitta inda zamu fitar da sakamakon, kuma ta hanyar da muka bayyana a baya muna kiran taga mahawara mai aiki TAMBAYA.

   A fagen "Range" mun shigar da daidaitawan farko shafi na tebur da muka sarrafa a baya.

   A fagen "Sharhin" shigar da wannan magana:

   Nama

   Wannan shine, wannan matakin ya samar da yanayin da zamu kirga dukkan abubuwanda suke cike da bayanan da basu dauke da kalmar Nama. Alamar "" yana nufin a Excel ba daidai ba.

   Bayan shigar da waɗannan saiti a cikin taga muhawara, danna kan maɓallin "Ok".



2. Sakamakon yana bayyana nan da nan a cikin sel da aka riga aka tsara. Ya ba da rahoton cewa a cikin shafi da aka zaɓa akwai abubuwa guda 190 tare da bayanai waɗanda basu da kalmar Nama.

Yanzu bari muyi a shafi na uku na wannan tebur lissafin duk dabi'un da suka fi adadin 150 girma.

1. Zaɓi wayar don nuna sakamakon kuma je zuwa taga muhawara na ayyuka TAMBAYA.

   A fagen "Range" shigar da daidaitawa na uku shafi na teburinmu.

   A fagen "Sharhin" Rubuta yanayin nan:

   >150

   Wannan yana nufin cewa shirin zai lissafa abubuwan abubuwan shafi waɗanda kawai suke ɗauke da lambobi sama da 150.

   Na gaba, kamar yadda koyaushe, danna maɓallin "Ok".



2. Bayan kirgawa, Excel yana nuna sakamakon a cikin tantanin halitta da aka riga aka tsara. Kamar yadda kake gani, shafin da aka zaɓa ya ƙunshi dabi'u 82 waɗanda suka zarce lamba 150.

Don haka, mun ga cewa a cikin Excel akwai hanyoyi da yawa don ƙidaya yawan ƙimar a cikin shafi. Zaɓin zaɓi na musamman ya dogara da takamaiman maƙasudin mai amfani. Don haka, mai nuna alama a kan mashigin matsayin yana ba ka damar ganin adadin duk ƙimar a cikin shafi ba tare da gyara sakamakon ba; aiki LATSA yana ba da zarafi don gyara lambarsu a cikin wani sel daban; mai aiki LABARI kawai kirga abubuwa masu dauke da bayanan lamba; kuma tare da aikin TAMBAYA Zaka iya saita yanayi mafi rikitarwa don kirga abubuwan.