E helu i nāʻikepili i nā Pūnaewele i kohoʻia me Excel COUNTIF

Hana ka hana COUNTIF i ka hana IF a me ka COUNT hana ma Excel. ʻO kēia huiʻana e hiki iāʻoe ke helu i ka helu o nā manawaʻikepili pololei i loaʻa i loko o kahi pūʻulu i kohoʻia.

ʻO ka mahele IF o ka hana e hoʻoholo i nāʻikepili i kū i nā pae hoʻohālikelike a me ka mahele COUNT ka helu.

Ka hana o COUNTIF ma kahi o ka Tutorial Tutorial

Ke hoʻohana nei kēia kumuhana i kahi hoʻonohonoho pūnaewele a me ka hana COUNTIF eʻike i ka helu o nā Reps Sales i loaʻa nāʻoihana 250 ma ka makahiki.

Ma hope o nā paepae i nā kumuhana kumuhana ma lalo nei e hele ana ma o ka hanaʻana a me ka hoʻohanaʻana i ka hana COUNTIF iʻikeʻia ma ke kiʻi ma luna nei e helu i ka helu kūʻai kūʻai me nāʻoihana 250 ma mua.

01 o 07

Nā kumuhana kumuhana

• E komo i loko o kaʻikepili aʻo
• ʻO ka SyntaxʻOihana COUNTIF
• Ke hoʻomaka nei i ka hana COUNTIF
• E komo i loko o ka manaʻo kumu
• Komo i loko o ka manaʻo kumu kumu
• Aʻo ka pane a ..

02 o 07

E komo i loko o kaʻikepili aʻo

ʻO ka hana mua i ka hoʻohanaʻana i ka hana COUNTIF ma Excel e komo i kaʻikepili.

E komo i nāʻikepili i loko o nā pūnaewele C1 i ka E11 o kahi hana hana Excel e like me ka mea iʻikeʻia ma ka kiʻi ma luna.

E hoʻokomoʻia ka hana COUNTIF a me nā pae huli (ʻoi aku ma mua o 250 mau kauoha) i ka lālani 12 ma lalo o kaʻikepili.

Nānā: ʻAʻole nā ​​papa aʻo aʻo i hoʻokomo i nā papa hana hoʻomākaukau no ka pepa hana.

ʻAʻole e hoʻohālike kēia i ka hoʻopauʻana i ke kumu aʻo. Eʻokoʻa paha kāu pepa hana ma mua o ke hiʻohiʻona i hōʻikeʻia, akā,ʻo ka hana COUNTIF e hāʻawi iāʻoe i nā hualoaʻa likeʻole.

03 o 07

ʻO ka SyntaxʻOihana COUNTIF

Ma Excel, kahi hana o ka syntax pili i ka hoʻolālā o ka hana a me ka inoa o nā hana, nā pale, a me nā manaʻo .

ʻO ka syntax no ka hana COUNTIF:

= COUNTIF (Keʻena, Criteria)

Nā hāʻina o COUNTIF

Hōʻike nā manaʻoihana o ka hana i ka hana i kahiʻano a mākou e hoʻokolohua nei a me keʻano o nāʻikepili e helu ai i ka manawa i kū ai keʻano.

Kaha - ka hui o nā pūnaewele kahi hana e huli.

Palapala Criteria - ua hoʻohālikeʻia kēia kumukūʻai me nāʻikepili i nā pūnaewele Kūlana . Ināʻikeʻia kahi papahana a laila heluʻia ka pūnaewele i loko o ka Range . Hiki ke hoʻokomoʻia nāʻikepili kūikawā a iʻole ka papa kuhikuhi pūnaewele i kaʻikepili no kēia manaʻo.

04 o 07

Ke hoʻomaka nei i ka hana COUNTIF

ʻOiai hiki ke hana wale i ka hana COUNTIF i loko o kahi pūnaewele i kahi papa hana , he nui nā kānaka i maʻalahi e hoʻohana i ka pahu kamaʻilio o kaʻoihana e komo i ka hana.

Nā Kūlana Haʻawina

1. E kaomi i ka pūnaewele E12 e lilo ia i ke kamepiula paʻamau . ʻO kēia kahi kahi e komo ai mākou i ka hana COUNTIF.
2. E kaomi i kaʻaoʻao Formulas o kahi kikokikona .
3. E koho i nā hana hou aʻe> Nāʻikepili mai ka lepikona e wehe i ka papa inoa iho o lalo.
4. Kaomi iā COUNTIF ma ka papa inoa e hāpai i ka pahuhopu o COUNTIF.

ʻO nāʻikepili i komo mākou i loko o nā pae pāhakaʻelua ma ka pahu kūkā e hoʻokumu i nā manaʻo o ka hana COUNTIF.

Ke hōʻike nei kēia mau manaʻo hoʻoholo i ka hana i keʻano o ka hoʻokolohuaʻana iā mākou a me nā pūnaewele e helu ai i ka manawa i kū ai keʻano.

05 o 07

E komo i loko o ka manaʻo kumu

Ma kēia kumuhana makemake mākou eʻike i ka helu o Sales Sales i kūʻai aku i nāʻoihana he 250 aʻoi aku no ka makahiki.

Hōʻikeʻia ka hōʻike o ka Range i ka hana COUNTIF i ka hui o nā pūnaewele e huli ai i ka ho'āʻoʻana eʻike i nāʻano i kohoʻia o "> 250" .

Nā Kūlana Haʻawina

1. Ma ka pahu kūkākūkā , e kaomi i ka laina Range .
2. E hōʻike i nā pūnaewele E3 i ka E9 ma ka pepa haʻawina e komo i kēia mau kikowaena pūnaewele e like me ka laina e huliʻia e ka hana.
3. E waiho i ka pahu hāmama no ka papa aʻe i ka papa kuhikuhi.

06 o 07

Komo i loko o ka manaʻo kumu kumu

Hōʻike ka papahana Criteria i COUNTIF i nāʻikepili e ho'āʻo ai e loaʻa ma ka hoʻopiʻi Range .

ʻOiai ua hiki ke hoʻokomoʻia nāʻikepili pūnaewele - pēlā i ka helu a iʻole nā ​​helu e like me "> 250" i loko o ka pahu pahu no kēia kumuhanaʻoi aku ka maikaʻi loa e komo i kahi kānana pūnaewele i loko o ka pahu dialog, e like me D12 a laila e hoʻokomo i nāʻikepili i makemake mākou e hoʻohālike. i loko o kēlā pūnaewele i ka pepa haʻawina.

Nā Kūlana Haʻawina

1. E kaomi i ka Lālā Palena i loko o ka pahu kūkākūkā.
2. E kaomi i ke kelepona D12 e komo i kēlā kuhikuhi maʻamau. E huli ka hana i ke ana i kohoʻia i ka haʻina mua no nāʻikepili i pili i nāʻikepili i komo i loko o kēia kamepiula.
3. Kaomi iā OK e pani i ka pahu pahu a hoʻopiha i ka hana COUNTIF.
4. Pono e paneʻia ka pane o ka'ōlohelohe i ke kelepona E12 - ke kelepona kahi i komo ai mākou i ka hana - no ka meaʻaʻole mākou i hoʻohui pū i nāʻikepili i ka māhele Criteria (D12).

07 o 07

Pākuʻi i nā Kumu Huli

ʻO ka hopena hope loa i loko o ka aʻoʻana, e hōʻaia i nā papahana e makemake mākou i ka hana e kūlike.

Ma kēia hihia, makemake mākou i ka helu o Sales Reps me nāʻoihana he 250 aʻoi aku no ka makahiki.

No ke hanaʻana i kēia hana, kā mākou e komo > 250 i D12 - ke kikowaena iʻikeʻia i loko o ka hana e like me ka pae hoʻohālike.

Nā Kūlana Haʻawina

1. I loko o ke kelepona D12 type > 250 a e kaomi i ka pihi komo ma ka papa keyboard.
2. Eʻike ka helu 4 i ke kelepona E12.
3. ʻO ka hua'ōlelo o "> 250" ua huiʻia ma nā māmāʻehā ma ke kalani E: E4, E5, E8, E9. No laila,ʻo kēia wale nō nā pūnaewele i heluʻia e ka hana.
4. Ke pāʻaniʻoe ma ke kelepona E12, ka hana piha
   = COUNTIF (E3: E9, D12) i loko o ka manaʻo ma luna o ka pepa haʻawina .