Lokacin aiwatar da wasu ayyuka yayin aiki tare da tebur, yana iya zama dole a ƙidaya sel da ke cike da bayanai. Excel yana ba da wannan tare da kayan aikin ginannun kayan aiki. Bari mu gano yadda ake aiwatar da ƙayyadadden aikin a cikin wannan shirin.
Kirkirar kirji
A cikin Excel, ana iya ganin adadin ƙwayoyin da aka cika ta amfani da counter a kan matsayin matsayin ko kuma yawan ayyuka, kowannensu yana kirga abubuwan da ke cike da wani nau'in bayanan.
Hanyar 1: kanta akan masalin halin
Hanya mafi sauki don ƙididdige ƙwayoyin da ke ɗauke da bayanai ita ce amfani da bayanin daga kan teburin, wanda ke a gefen dama na masaniyar matsayi zuwa hagu na maɓallan don sauya hanyoyin kallo a cikin Excel. Yayinda aka fifita iyaka akan takaddun da dukkan abubuwan babu komai ko guda ɗaya kawai ya ƙunshi wasu ƙimar, wannan mai nuna yana ɓoye. Kasuwanci yana bayyana ta atomatik lokacin da aka zaɓi sel biyu ko fiye waɗanda ba komai, kuma nan da nan nuna lambar su bayan kalmar "Yawan".
Amma, kodayake an kunna wannan kanta ta tsohuwa, kuma tana jira kawai don mai amfani ya haskaka wasu abubuwan, a wasu halaye ana iya kashe shi da hannu. Sannan tambayar hadahadar ta zama mai dacewa. Don yin wannan, danna-dama a kan matsayin matsayin kuma a cikin jerin da ya bayyana, duba akwatin kusa "Yawan". Bayan haka, za a sake nuna counter ɗin.
Hanyar 2: aikin COUNT
Za'a iya kirga yawan adadin sel da aka cika ta amfani da aikin COUNT. Ya bambanta da hanyar da ta gabata a cikin wannan yana ba ku damar gyara lissafin wani kewayon cikin sel daban. Wato, don duba bayani game da shi, yanki ba zai buƙatar ɗaukar yanki koyaushe.
- Zaɓi yankin wanda za'a nuna sakamakon kirgawa. Danna alamar "Saka aikin".
- Ana buɗe mai kunna Wurin Aiki. Muna neman kashi a cikin jerin BATSA. Bayan an fifita wannan sunan, danna kan maballin "Ok".
- Daga nan sai taga gardamar ta fara. Hujjojin wannan aikin nassoshi ne na kwayar halitta. Za'a iya saita hanyar haɗi zuwa kewayon da hannu, amma ya fi kyau saita siginan kwamfuta a cikin filin "Darajar1"Inda kake son shigar da bayanai, sai ka zabi yankin da yake daidai a kan takardar. Idan kana son kirga cikakken sel a cikin jeri da yawa da aka rabu da juna, to dole ne a shigar da hanyoyin na biyu, na uku da masu zuwa a cikin filayen da ake kira "Darajar2", "Darajar 3" da sauransu Lokacin da aka shigar da duk bayanan. Latsa maballin "Ok".
- Hakanan za'a iya shigar da wannan aikin da hannu a cikin sel ko layin dabara, waɗanda ke biye da asalin kalmar:
= COUNT (darajar1; darajar2; ...) - Bayan an shigar da dabara, shirin a yankin da aka riga aka zaɓa yana nuna sakamakon ƙidaya yawan sel da aka ƙaddara.
Hanyar 3: aikin COUNT
Bugu da kari, don kirga cikakkun sel a cikin Excel akwai kuma lissafin aiki. Ba kamar ƙididdigar da ta gabata ba, tana ƙidaya ƙwayoyin da ke cike da lambobi ne kawai.
- Kamar yadda ya gabata, zaɓi sashin wayar wanda za'a nuna bayanan kuma a cikin saitin Gudanar da Ayyukan Aiki. A ciki ne muke zaɓar mai aiki tare da sunan "LATSA". Latsa maballin "Ok".
- Daga nan sai taga gardamar ta fara. Muhawara daidai take da amfani da hanyar da ta gabata. Matsayirsu an sake ambata zuwa sel. Mun shigar da daidaitawar jeri a kan takardar da kake buƙatar ƙidaya yawan adadin sel cike da lambobi. Latsa maɓallin "Ok".
Don gabatarwar jagorar wannan dabarar, muna bin diddigin wadannan:
= COUNT (darajar1; darajar2; ...) - Bayan wannan, a cikin yankin da ke wurin samar da tsari, yawan ƙwayoyin da ke cike da lambobin adadi zasu nuna.
Hanyar 4: aikin COUNTIF
Wannan aikin yana ba ku damar lissafin adadin ƙwayoyin da ke cike da maganganun lambobi, kawai waɗanda ke dacewa da wani yanayin. Misali, idan ka saita yanayin "> 50", to kawai waɗannan sel waɗanda ke ɗauke da darajar da suka fi yawan 50 ɗin za'a kula dasu. Hakanan zaka iya saita ƙimar "<" (ƙasa), "" (ba daidai ba), da sauransu.
- Bayan da ka zaɓi tantanin halitta don nuna sakamakon sannan ka ƙaddamar da Wurin Aiki, zaɓi shigarwar "COUNTIF". Latsa maballin "Ok".
- Tattaunawa ta buɗe tana buɗewa. Wannan aikin yana da muhawara guda biyu: kewayon inda ake ƙididdige sel, da tantancewa, wato, yanayin da muka yi magana a sama. A fagen "Range" shigar da daidaitawar yankin da aka sarrafa, da kuma a fagen "Sharhin" shigar da yanayin. Bayan haka, danna maɓallin "Ok".
Don shigar da jagora, samfuri kamar haka:
= COUNTIF (kewa; rarrabuwa) - Bayan wannan, shirin yana ƙididdige cikakken sel na kewayon da aka zaɓa, wanda ya dace da yanayin da aka ƙayyade, kuma yana nuna su a cikin yankin da aka ƙayyade a sakin farko na wannan hanyar.
Hanyar 5: aikin COUNTIF
Ma'aikacin COUNTIF sigar asali ce ta aikin COUNTIF. Ana amfani dashi lokacin da kuke buƙatar tantance yanayin da ya dace sama da ɗaya don jeri daban-daban. A jimilla, zaku iya tantance har zuwa yanayin 126.
- Mun tsara tantanin halitta wanda za'a nuna sakamakon shi kuma mai sarrafa Zazzabin Aiki. Muna neman abu a ciki "KUDI". Zaɓi shi kuma danna maballin. "Ok".
- Tattaunawa ta buɗe tana buɗewa. A zahiri, muhawarorin aiki daidai suke da na baya - "Range" da "Yanayi". Bambancin kawai shine cewa za'a iya samun adadin jeri da kuma yanayin dacewa. Shigar da adiresoshin lamuran da yanayin aiki, sannan danna maɓallin "Ok".
Ginin kalma na wannan aikin kamar haka:
= COUNTIME (yanayi_range1; sharadin1; sharadin_range2; sharadin2; ...) - Bayan wannan, aikace-aikacen yana kirga cikakken sel na ƙayyadaddun jeri, wanda ya dace da yanayin da aka kafa. An nuna sakamakon a yankin da aka yi wa alama.
Kamar yadda kake gani, mafi sauƙin ƙidaya yawan adadin ƙwayoyin da aka cika a cikin zaɓin da aka zaɓa ana iya ganin su a mashigar matsayin Excel. Idan kuna buƙatar nuna sakamakon a cikin wani yanki daban akan takardar, har ma fiye da haka don yin ƙididdigar, la'akari da wasu yanayi, to a wannan yanayin ayyuka na musamman zasu zo don ceto.
