COUNTIF ya sake dawo da ƙidayar yanayin ƙididdigar wani yanki
Ayyukan COUNTIF ya haɗa aikin IF da aikin COUNT a cikin Google Sheets. Wannan haɗin yana ba ka damar ƙidaya adadin lokutan da aka samo bayanan da aka samo a cikin jerin zaɓuɓɓukan da aka zaɓa da suka hadu da wani ma'auni guda ɗaya, wanda aka ƙayyade. Ga yadda aikin yake aiki:
- Da IF wani ɓangare na aikin yana ƙayyade abin da bayanai ke haɗu da ƙayyadaddun bayanin.
- Ƙungiyar COUNT na aiki tana ƙididdiga yawan yawan kwayoyin da ke bin ka'idar.
Ayyukan COUNTIF & # 39; s Syntax da Arguments
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, ɓangaren sharaɗi da kuma muhawara . Hadawa don aikin COUNTIF shine:
= COUNTIF (iyakar, ma'auni)
Tsarin shine rukuni na sel da aikin shine don bincika. Sakamakon ya ƙayyade ko an gano tantanin tantanin da aka gano a cikin jayayya na yanki ko a'a. Sakamakon zai iya zama:
- Lambar.
- Tsararren tantancewar salula zuwa wurin samo bayanai a cikin takardun aiki, kamar B12.
- Fassarar, kamar 100, "<= = 1000" ko "<>" & B12.
- Bayanin rubutu ko rubutu na rubutu , kamar "Jigogi."
Idan lamarin ya kunshi lambobi:
- Aikin mai kwatanta kamar > (mafi girma fiye da), <= (kasa da ko daidai da), ko <> (ba daidai ba) za a iya amfani dashi a cikin wata kalma kuma kowace tantanin halitta a cikin kewayo an duba su don ganin idan ya dace da ka'idar .
- Don ƙudirin neman daidaitattun daidaito, alamar daidai bazai buƙaci a haɗa shi cikin magana ba, kuma darajar ba ta buƙatar a haɗa shi cikin alamomi. Alal misali, ana iya amfani da 100 don maganganun gardama maimakon "= 100" ko da yake dukansu zasu yi aiki.
- Don maganganun da ba daidai ba wanda bai haɗa da halayen salula ba, dole ne a haɗa dukkanin magana a kalmomi biyu , kamar "<= 1000"
- Don maganganu ta yin amfani da misalai da masu amfani da su da kuma tantancewar salula, ba a jigilar tantancewar salula a cikin kalmomi biyu, kamar "<>" & B12 ko "<=" & C12.
- Don maganganu ta yin amfani da misalai da masu amfani da su da kuma tantancewar salula, mai aiki na kwatanta ya haɗa da amintar salula ta amfani da ampersand ( & ), wanda shine yanayin haɗuwa a Excel da Google Sheets, kamar "<>" & B12 ko "<=" & C12.
Idan hujja ta jigilar ta ƙunshi bayanan rubutu:
- Dole ne kalmomin rubutun kalmomi su kasance a cikin alamomi guda biyu, kamar "raguwa."
- Kalmomin rubutu na iya ƙunsar ? da * haruffan haruffan don su dace da ɗaya (?) ko maɓalli (*) haruffan haruffa.
- Don daidaita ainihin? ko *, ya sa waɗannan haruffa tare da tilde irin su ~? da kuma * *.
COUNTIF Ayyukan ayyuka
Kamar yadda aka nuna a cikin hoton da ke haɗuwa da wannan labarin, ana amfani da aikin COUNTIF don samo yawan yawan kwayoyin bayanai a shafi A wannan matsala wasu sharuddan. Ana nuna alamun COUNTIF a cikin rukunin B kuma ana nuna nauyin kanta a shafi na C.
- Na farko layuka biyar na misali suna da bayanan rubutu don aikin aikin jayayya da kuma amfani da sassan A2 zuwa A6 don jigidar gardama.
- Ƙarshen layuka biyar na da lambar ƙididdiga don jayayya.
Shigar da aikin COUNT
Google Sheets ba ya amfani da akwatunan maganganu don shigar da muhawarar aiki kamar ka samu a Excel. Maimakon haka, yana da akwati na nuna kai tsaye wanda ya tashi kamar yadda aikin aikin ya shiga cikin tantanin halitta. Matakan da ke ƙasa dalla-dalla shigar da aikin COUNTIF da ƙwararrakin da yake cikin tantanin halitta B11 na misali misali. A cikin wannan tantanin, COUNTIF yayi bincike kan iyakar A7 zuwa A11 don lambobin da suka kasa ko daidai da 100,000.
Don shigar da aikin COUNTIF da ƙididdiga kamar yadda aka nuna a cikin sakon B11 na hoton:
- Danna kan tantanin halitta B11 don sa shi tantanin halitta mai aiki . Wannan shi ne inda sakamakon aikin COUNTIF za a nuna.
- Rubuta alamar daidai ( = ) biye da sunan aikin aiki .
- 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 COUNTIF ya bayyana a akwatin, danna maɓallin shigarwa a kan keyboard don shigar da aikin aikin kuma bude sashin layi a jikin B11.
- Sanya siffofin A7 zuwa A11 don haɗa su a matsayin ƙwaƙwalwar kewayon aikin.
- Rubuta takaddama don aiki a matsayin mai raba tsakani tsakanin kewayo da jayayya.
- Bayan rikici, rubuta kalmar "<=" & C12 don shigar da shi a matsayin hujja na jigilar.
- Latsa maɓallin shigarwa a kan keyboard don shigar da takalmin rufewa kuma kammala aikin.
- Amsar ta 4 ya kamata ta bayyana a cikin tantanin halitta B11 tun lokacin da dukkanin kwayoyin halitta guda hudu ke cikin jigilar lamuni sun ƙunshi lambobin da suka fi ko daidai da 100,000.
- Lokacin da ka danna kan tantanin B11 , cikakkiyar tsari = bada shawara (A7: A10, "<=" & C12 ya bayyana a cikin maƙallin ƙididdiga a sama da takardun aiki .