Wataƙila kun riga kun san cewa Excel na iya yin lissafi da lambobi. Amma ka san cewa yana iya yin lissafi akan wasu nau'ikan bayanai? Ɗaya daga cikin misalan mafi sauƙi shine aikin COUNTA (SCHYOTZ). Aiki COUNT yana duba kewayon sel kuma ya ba da rahoton nawa ne ke ɗauke da bayanai. A wasu kalmomi, yana neman sel marasa fanko. Wannan fasalin yana da amfani a yanayi daban-daban.
Idan baku taɓa yin aiki tare da ayyukan Excel ba, to zai zama da amfani a gare ku don shiga cikin jerin darussa daga sashin Formula da Ayyuka Koyarwar mu ta Excel don Masu farawa. Aiki COUNT yana aiki iri ɗaya a duk nau'ikan Excel, da sauran maƙunsar bayanai kamar Google Sheets.
Ka yi la’akari da misalin
A cikin wannan misalin, muna amfani da Excel don tsara wani taron. Mun aika gayyata ga kowa da kowa, kuma idan muka sami amsoshi, muna shigar da "Ee" ko "A'a" a cikin rukunin. C. Kamar yadda kake gani, a cikin ginshiƙi C akwai sel marasa komai, domin har yanzu ba a sami amsoshin daga duk waɗanda aka gayyata ba.
Ƙididdigar martani
Za mu yi amfani da aikin COUNTdon kirga mutane nawa ne suka amsa. A cikin tantanin halitta F2 shigar da alamar daidai da sunan aikin COUNTA (SCHÖTZ):
=COUNTA
=СЧЁТЗ
Kamar yadda yake tare da kowane aiki, dole ne a haɗa gardama a cikin baka. A wannan yanayin, muna buƙatar hujja ɗaya kawai: kewayon sel da muke son bincika ta amfani da aikin COUNT. Amsoshin "Ee" ko "A'a" suna cikin sel ku: ku2, amma za mu haɗa wasu ƙarin layukan a cikin kewayon idan muna buƙatar gayyatar ƙarin mutane:
=COUNTA(C2:C100)
=СЧЁТЗ(C2:C100)
Bayan danna Shigar Za ku ga cewa an sami amsoshi 55. Yanzu ga ɓangaren nishaɗi: za mu iya ci gaba da ƙara sakamako a cikin maƙunsar bayanai yayin da muke samun martani, kuma aikin zai sake ƙididdige sakamakon ta atomatik don ba mu amsa daidai. Gwada buga "Ee" ko "A'a" a kowace tantanin halitta mara komai a cikin ginshiƙi C kuma ga cewa darajar a cikin tantanin halitta F2 ya canza.
Ƙididdigar waɗanda aka gayyata
Hakanan muna iya ƙidaya adadin mutanen da muka gayyata. A cikin tantanin halitta F3 shigar da wannan dabara kuma latsa Shigar:
=COUNTA(A2:A100)
=СЧЁТЗ(A2:A100)
Duba yadda sauki yake? Muna buƙatar kawai saka wani kewayon (A2: A100) kuma aikin zai ƙidaya adadin sunaye a cikin shafi. Sunan rana, mayar da sakamakon 85. Idan kun ƙara sabbin sunaye a ƙasan tebur, Excel zai sake ƙididdige wannan ƙimar ta atomatik. Koyaya, idan kun shigar da wani abu a ƙasan layi na 100, to kuna buƙatar gyara kewayon da aka ƙayyade a cikin aikin ta yadda duk sabbin layukan aka haɗa a ciki.
Tambayar Bonus!
Yanzu muna da adadin martani a cikin tantanin halitta F2 da jimillar adadin waɗanda aka gayyata a cikin tantanin halitta F3. Zai yi kyau a lissafta adadin adadin mutanen da aka gayyata suka amsa. Bincika kanka idan zaka iya rubutawa a cikin tantanin halitta da kanka F4 dabarar ƙididdige rabon waɗanda suka amsa jimlar adadin waɗanda aka gayyata a matsayin kaso.
Yi amfani da bayanan salula. Muna buƙatar tsari wanda koyaushe za a sake ƙididdige shi lokacin da aka yi canje-canje a teburin.