Ƙididdiga bayanai a cikin Sassan Zaɓaɓɓu tare da TURKAR CIKIN

Ayyukan COUNTIF ya haɗa aikin IF da aikin COUNT a Excel. Wannan haɗin yana ba ka damar ƙidaya adadin lokutan da aka samo bayanai musamman a cikin ƙungiyar da aka zaɓa ta sel.

Da IF wani ɓangare na aikin yana ƙayyade abin da bayanai ke haɗu da ƙayyadaddun ka'idodi da ƙungiyar COUNT ta ƙidayawa.

COUNTIF Ayyukan Mataki na Mataki na Mataki

Wannan koyaswar tana amfani da saitin bayanan bayanan da aikin COUNTIF don gano yawan adadin tallace-tallace da ke da fiye da lambobi 250 a shekara.

Biye da matakai a cikin darussan da ke ƙasa ke tafiya ta hanyar samarwa da yin amfani da aikin COUNTIF da aka gani a cikin hoton da ke sama don ƙidaya yawan adadin tallace-tallace tare da umarni fiye da 250.

01 na 07

Tutorial Topics

• Shigar da Bayanan Tutorial
• Hanyoyin Sakamakon COUNTIF
• Fara aikin COUNTIF
• Shigar da Magana na Range
• Shigar da Sharuddan Magana
• Kuma Amsar ita ce ..

02 na 07

Shigar da Bayanan Tutorial

Mataki na farko don yin amfani da aikin COUNTIF a Excel shine shigar da bayanai.

Shigar da bayanai zuwa cikin sassan C1 zuwa E11 na takardar aiki na Excel kamar yadda aka gani a cikin hoto a sama.

Ayyukan COUNTIF da tsarin bincike (mafi girma fiye da umarni 250) za a kara zuwa jere 12 a kasa da bayanan.

Lura: Umurni na koyawa ba sun haɗa da matakan tsarawa don aikin aiki ba.

Wannan ba zai dame shi ba tare da kammala tutorial. Kayan aikinku zai bambanta da misalin da aka nuna, amma aikin COUNTIF zai ba ku sakamakon wannan.

03 of 07

Hanyoyin Sakamakon COUNTIF

A cikin Excel, haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, da muhawara .

Hadawa don aikin COUNTIF shine:

= COUNTIF (Range, Criteria)

Tambayoyin COUNTIF Ayyuka

Ayyukan aikin na nuna aikin abin da muke gwadawa kuma wane irin bayanai don ƙidaya lokacin da yanayin ya hadu.

Range - rukuni na sel da aikin shine don bincika.

Tura - wannan darajar an kwatanta da bayanan da ke cikin sel. Idan an sami wasa sai an kidaya tantanin halitta a Range . Ana iya shigar da bayanai na ainihi ko tantancewar tantanin halitta zuwa bayanai don wannan hujja.

04 of 07

Fara aikin COUNTIF

Kodayake yana yiwuwa don kawai rubuta aikin COUNTIF a cikin tantanin halitta a cikin takardun aiki , mutane da yawa sun fi sauƙi don amfani da maganganun maganganun don shigar da aikin.

Tutorial Steps

1. Danna kan tantanin halitta E12 don yin sautin mai aiki . Wannan shi ne inda za mu shiga aikin COUNTIF.
2. Danna kan Rubutun shafin shafin rubutun .
3. Zaɓi Ƙari Ayyuka> Lissafi daga rubutun don buɗe jerin sauƙaƙe aikin.
4. Danna COUNTIF a cikin jerin don kawo akwatin maganganun COUNTIF.

Bayanin da muka shiga cikin layuka guda biyu a cikin akwatin maganganu zasu haifar da muhawarar aikin COUNTIF.

Wadannan muhawara suna nuna aikin abin da muke gwaji don kuma abin da kwayoyin za su ƙidaya lokacin da yanayin ya hadu.

05 of 07

Shigar da Magana na Range

A cikin wannan koyaswar muna so mu sami adadin kudaden Sales wanda ya sayar da fiye da 250 umarni a shekara.

Shawarar Range ta nuna aikin COUNTIF wanda rukuni na sel ya bincika yayin ƙoƙarin gano ka'idodin "> 250" .

Tutorial Steps

1. A cikin akwatin maganganu , danna kan Ranar Range .
2. Fassara sel E3 zuwa E9 a kan takardun aiki don shigar da waɗannan ƙididdigar cell kamar yadda kewayar da za a bincika.
3. Ka bar akwatin maganganu don buɗe mataki na gaba a cikin koyawa.

06 of 07

Shigar da Sharuddan Magana

Shawarar Criteria ya gaya wa COUNTIF abin da ya kamata ya yi ƙoƙari ya samu a cikin Tunaniyar Range .

Kodayake ainihin bayanai - irin su rubutu ko lambobi kamar "> 250" za'a iya shiga cikin maganganun maganganun wannan hujja mafi yawa shine shigar da tantanin halitta a cikin maganganun maganganu, kamar D12 sannan kuma shigar da bayanan da muke so mu daidaita cikin tantanin ɗin a cikin takardun aiki.

Tutorial Steps

1. Danna kan layi a cikin akwatin maganganu.
2. Danna kan tantanin halitta D12 don shigar da wannan tantanin salula. Ayyukan za su bincika tasirin da aka zaba a mataki na baya don bayanai wanda ya dace da duk bayanai da aka shiga cikin wannan tantanin halitta.
3. Danna Ya yi don rufe akwatin maganganu kuma kammala aikin COUNTIF.
4. Amsar da zero ya kamata ya bayyana cikin tantanin halitta E12 - tantanin halitta inda muka shiga aikin - saboda ba mu riga muka kara bayanai zuwa filin Jagora (D12) ba.

07 of 07

Ƙara Matakan Bincike

Mataki na karshe a cikin koyawa shine don ƙara ma'auni da muke so aikin ya dace.

A wannan yanayin muna son yawan tallace-tallace na Sales tare da umurnin fiye da 250 a shekara.

Don yin wannan zamu shiga > 250 a cikin D12 - tantanin tantanin halitta da aka gano a cikin aikin kamar yadda yake dauke da hujja .

Tutorial Steps

1. A cikin cell D12 type > 250 kuma danna maɓallin shigarwa akan keyboard.
2. Yawan lamba 4 ya kamata ya bayyana a cikin cell E12.
3. Sakamakon "> 250" an haɗu a cikin kwayoyin hudu a shafi na E: E4, E5, E8, E9. Saboda haka wadannan su ne kawai kwayoyin da aka ƙidaya ta aikin.
4. Lokacin da ka danna kan tantanin halitta E12, cikakken aikin
   = COUNTIF (E3: E9, D12) ya bayyana a cikin maɓallin tsari a sama da takardun aiki .