Sau da yawa, lokacin aiki a cikin Excel, kuna buƙatar ƙidaya adadin sel akan takardar aiki. Waɗannan na iya zama fanko ko cike da sel waɗanda ke ɗauke da ƙimar lambobi kawai, kuma a wasu lokuta, abubuwan da ke cikin su dole ne su cika wasu sharudda. A cikin wannan koyawa, za mu yi cikakken nazari kan manyan ayyuka guda biyu na Excel don kirga bayanai - duba и COUNTIF, da kuma samun saba da marasa farin jini – SCHETZ, COUNTBLANK и COUNTIFS.
DUBA()
aikin kididdiga duba yana ƙidaya adadin ƙwayoyin sel a cikin jerin gardama waɗanda ke ɗauke da ƙimar lambobi kawai. Misali, a cikin hoton da ke ƙasa, mun ƙidaya adadin sel a cikin kewayon da ya ƙunshi lambobi gaba ɗaya:
A cikin misali mai zuwa, sel kewayo biyu sun ƙunshi rubutu. Kamar yadda kake gani, aikin duba yayi watsi dasu.
Amma ana la'akari da sel masu ɗauke da ƙimar kwanan wata da lokaci:
aiki duba zai iya ƙidaya adadin ƙwayoyin sel a cikin jeri da yawa waɗanda ba su da alaƙa a lokaci ɗaya:
Idan kana buƙatar ƙidaya adadin sel marasa fanko a cikin kewayon, zaku iya amfani da aikin ƙididdiga SCHETZ. Kwayoyin da ke ɗauke da rubutu, ƙimar lamba, kwanan wata, lokaci, da ƙimar boolean GASKIYA ko KARYA ana ɗaukar su ba fanko ba.
Magance matsalar juzu'i, watau ƙidaya adadin sel mara komai a cikin Excel, zaku iya amfani da aikin COUNTBLANK:
COUNTIF()
aikin kididdiga COUNTIF yana ba ku damar ƙidaya sel na takaddar aikin Excel ta amfani da nau'ikan yanayi daban-daban. Misali, dabarar da ke ƙasa tana mayar da adadin sel waɗanda ke ɗauke da ƙima mara kyau:
Wannan dabarar tana mayar da adadin sel waɗanda darajarsu ta fi abin da ke cikin tantanin halitta A4.
COUNTIF yana ba ku damar kirga sel masu ɗauke da ƙimar rubutu. Misali, dabarar da ke biyowa tana mayar da adadin ƙwayoyin da ke ɗauke da kalmar “rubutu” kuma yanayin rashin jin daɗi.
Yanayin aikin Boolean COUNTIF na iya ƙunsar manyan katuna: * (asterik) kuma ? (alamar tambaya). Alamar alama tana nufin kowane adadin haruffa sabani, yayin da alamar tambaya tana tsaye ga hali ɗaya na sabani.
Misali, don ƙidaya adadin ƙwayoyin da ke ɗauke da rubutu waɗanda ke farawa da harafi Н (wanda ba shi da hankali), zaku iya amfani da dabara mai zuwa:
Idan kana buƙatar ƙidaya adadin sel waɗanda ke ɗauke da haruffa huɗu daidai, to yi amfani da wannan dabara:
aiki COUNTIF ba ka damar amfani da ko da dabara a matsayin sharadi. Misali, don kirga adadin sel masu kima fiye da matsakaici, zaku iya amfani da dabara mai zuwa:
Idan yanayi ɗaya bai ishe ku ba, koyaushe kuna iya amfani da aikin ƙididdiga COUNTIFS. Wannan aikin yana ba ku damar ƙidaya sel a cikin Excel waɗanda suka gamsar da sharuɗɗa biyu ko fiye a lokaci ɗaya.
Misali, dabarar da ke gaba tana ƙidaya sel waɗanda ƙimarsu ta fi sifili amma ƙasa da 50:
aiki COUNTIFS yana ba da damar ƙidaya sel ta amfani da yanayi И. Idan kuna son ƙididdige adadin tare da yanayin OR, kuna buƙatar amfani da ayyuka da yawa COUNTIF. Misali, dabara mai zuwa tana ƙirga sel waɗanda suka fara da harafi А ko da wasika К:
Ayyukan Excel don kirga bayanai suna da amfani sosai kuma suna iya zuwa da amfani a kusan kowane yanayi. Ina fatan cewa wannan darasi ya bayyana muku duk sirrin ayyuka. duba и COUNTIF, da kuma makusantansu – SCHETZ, COUNTBLANK и COUNTIFS. Dawo mana da yawa. Duk mafi kyau a gare ku da nasara a cikin koyon Excel.
yi ovo!