Mawerengedwe Owerengera Maselo Osankhidwa ndi Excel COUNTIF

Ntchito COUNTIF imaphatikizapo ntchito IF ndi COUNT zikugwira ntchito mu Excel. Kuphatikizanaku kukupatsani kuwerengera nthawi zomwe zimapezeka pazinthu zina zosankhidwa.

Ngati IF gawo la ntchitoyi limatsimikizira kuti deta ikugwirizana ndi chiwerengero choyikidwa ndipo gawo COUNT likuwerengera.

KHALANI KUGWIRITSIRA NTCHITO YOTSATIRA Phunziro

Phunziroli limagwiritsa ntchito ndondomeko ya ma data ndi COUNTIF ntchito kuti mupeze chiwerengero cha Sales Reps omwe ali ndi malamulo oposa 250 a chaka.

Kutsatira ndondomeko m'mitu ya maphunziro yomwe ili pansipa ikukuthandizani kudalenga ndikugwiritsa ntchito COUNTIF ntchito yomwe ikuwonetsedwa pa chithunzi pamwambapa kuti muwerenge chiwerengero cha malonda a malonda ndi malamulo oposa 250.

01 a 07

Mitu Yophunzitsa

• Kulowa Datorial Data
• Syntax ya COUNTIF ya Ntchito
• Kuyambira COUNTIF Ntchito
• Kulowa Mtsutso Wokambirana
• Kulowa Mtsutso Wotsutsa
• Ndipo Yankho liri ..

02 a 07

Kulowa Datorial Data

Njira yoyamba yogwiritsira ntchito COUNTIF ntchito ku Excel ndikolowetsa deta.

Lowani deta mu maselo C1 mpaka E11 a pepala la Excel monga momwe tawonera pa chithunzi pamwambapa.

Ntchito COUNTIF ndi zofufuzira (malamulo oposa 250) zidzawonjezedwa ku mzere 12 pansi pa deta.

Zindikirani: Mauthenga a maphunziro saphatikizapo kukonza mapepala a tsamba.

Izi sizidzasokoneza kukwaniritsa maphunziro. Tsamba lanu la ntchito lidzawoneka mosiyana ndi chitsanzo chikuwonetsedwa, koma ntchito COUNTIF idzakupatsani zotsatira zomwezo.

03 a 07

Syntax ya COUNTIF ya Ntchito

Mu Excel, syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakita, ndi zifukwa .

Mawu omasulira a COUNTIF ndi:

= COUNTIF (Zambiri, Zowonjezera)

Maganizo a COUNTIF Ogwira Ntchito

Mfundo zokhudzana ndi ntchitoyi zimapangitsa kuti ntchitoyo izikhala ndi chikhalidwe chiti chomwe tikuyesera komanso kuti ndi deta yambiri yowerengera kuti chikhalidwe chikuyendera.

Mtundu - gulu la maselo ntchitoyo ndi kufufuza.

Zolinga - mtengo uwu umafanizidwa ndi deta mu maselo a Range . Ngati macheza amapezeka ndiye selo mu Range amawerengedwa. Dongosolo lenileni kapena mawonekedwe a selo pa deta angalowetsedwe pazitsutsano izi.

04 a 07

Kuyambira COUNTIF Ntchito

Ngakhale kuti n'zotheka kungolemba ntchito COUNTIF mu selolo, anthu ambiri amavutika kuti agwiritse ntchito bokosi la polojekitiyi kuti alowe ntchitoyo.

Maphunziro Otsogolera

1. Dinani pa selo E12 kuti mupange selo yogwira ntchito . Apa ndi pamene tidzalowa ntchito COUNTIF.
2. Dinani pa Fomu tab ya riboni .
3. Sankhani Ntchito Zambiri> Chiwerengero chochokera ku riboni kuti mutsegule ntchitoyi.
4. Dinani pa COUNTIF mu mndandanda kuti mubweretse bokosi la COUNTIF la ntchito.

Deta yomwe timalowa muzitsulo ziwiri zosalumikizidwa mu bokosi la zokambirana zikhoza kupanga zifukwa za COUNTIF ntchito.

Zokambirana izi zimapereka ntchito yomwe tikuyesera ndi zomwe maselo angawerengere pamene chikhalidwe chikuyendera.

05 a 07

Kulowa Mtsutso Wokambirana

Mu phunziroli tikufuna kupeza chiwerengero cha Sales Reps omwe agulitsa maola oposa 250 a chaka.

Mtsutso wa Range umatiwuza COUNTIF ntchito yomwe gulu la maselo lifufuze pamene likuyesera kupeza zoyenera za "> 250" .

Maphunziro Otsogolera

1. Mu bokosi la bokosi , dinani pa Range line.
2. Onetsani maselo E3 ku E9 pa tsamba kuti mulowetse maumboni awa monga momwe angayang'anire ndi ntchitoyi.
3. Chokani ku bokosi lamasamba kutsegulira gawo lotsatira mu phunziroli.

06 cha 07

Kulowa Mtsutso Wotsutsa

Mtsutso wa Criteria umauza COUNTIF chidziwitso chimene ayenera kuyesa kuti chipeze mu ndondomeko ya Range .

Ngakhale ma data enieni - monga malemba kapena manambala onga ">> 250" angathe kulowa mu bokosi lazokambirana pazokambirana izi ndi bwino kuti tilowetse selolo mu bokosi, monga D12 ndikulowetsa deta yomwe tikufuna kufanana kulowa mu selololo mu worksheet.

Maphunziro Otsogolera

1. Dinani pa mzere wa zofunikira mu bokosi la dialog.
2. Dinani pa selo D12 kuti mulowetse selolo. Ntchitoyi idzafufuza zotsatira zomwe zasankhidwa kumbuyo kwa deta yomwe ikugwirizana ndi chilichonse chimene chinalowa mu selo ili.
3. Dinani OK kuti mutsegule bokosi la bokosi ndi kumaliza ntchito COUNTIF.
4. Yankho la zero liyenera kuoneka mu selo E12 - selo kumene tinalowa ntchito - chifukwa sitinayambe kuwonjezerapo deta kumunda wa Criteria (D12).

07 a 07

Kuwonjezera Zofuna Zosaka

Gawo lomaliza la phunziroli ndi kuwonjezera zomwe tikufuna kuti ntchitoyi ikhale yogwirizana.

Pachifukwa ichi tikufuna chiwerengero cha Sales Reps ndi malamulo oposa 250 a chaka.

Kuti tichite zimenezi timalowa > 250 kupita ku D12 - selo lozindikiritsidwa m'ntchito ngati liri ndi ndondomeko yoyenera.

Maphunziro Otsogolera

1. Mu selo D12 mtundu > 250 ndipo pindani makiyi a Enter mu makina.
2. Nambala 4 iyenera kuoneka mu selo E12.
3. Mndandanda wa "> 250" ukugwirizanitsidwa mumaselo anai mu ndime E: E4, E5, E8, E9. Kotero izi ndizo maselo okha omwe amawerengedwa ndi ntchito.
4. Mukasindikiza pa selo E12, ntchito yonse
   = COUNTIF (E3: E9, D12) ikuwoneka muzenera zamatabwa pamwamba pa tsamba .