Excel's COUNTIF thiab COUNTA cov haujlwm tuaj yeem ua ke kom pom qhov feem pua ntawm cov nqi tshwj xeeb hauv ntau cov ntaub ntawv. Tus nqi no tuaj yeem yog cov ntawv, lej, Boolean qhov tseem ceeb lossis lwm yam ntaub ntawv.
Qhov piv txwv hauv qab no muab ob txoj haujlwm los xam qhov feem pua ntawm Yes / Tsis muaj lus teb hauv ntau cov ntaub ntawv.
Tus qauv siv los ua kom tiav txoj haujlwm no yog:
=COUNTIF(E2:E5, "Yes")/COUNTA(E2:E5)
Qhia cov cim nyob ib puag ncig lo lus "Yes" hauv cov qauv. Tag nrho cov ntawv tseem ceeb yuav tsum muaj nyob rau hauv cov lus hais thaum nkag mus rau hauv Excel tus qauv.
Hauv qhov piv txwv, COUNTIF muaj nuj nqi suav cov sijhawm cov ntaub ntawv xav tau - cov lus teb Yog - pom nyob rau hauv pawg xaiv ntawm cov hlwb.
COUNTA suav tag nrho cov xov tooj ntawm tib qhov ntau yam uas muaj cov ntaub ntawv, tsis quav ntsej cov hlwb dawb.
Piv txwv: Nrhiav Qhov Feem Xyuam Ntawm Cov Neeg Pov Npav
Raws li tau hais los saum toj no, qhov piv txwv no pom qhov feem pua ntawm "Yes" cov lus teb hauv cov npe uas tseem muaj "Tsis yog" cov lus teb thiab lub xov tooj dawb.
Nkag mus rau COUNTIF - COUNTA Formula
- Click on cell E6 ua kom nws lub cev muaj zog;
- Type in the formula:=COUNTIF(E2:E5, "Yes")/COUNTA(E2:E5);
- Nias lub Enter key ntawm cov keyboard kom tiav cov qauv;
- Cov lus teb 67% yuav tsum tshwm sim hauv cell E6.
Vim tias tsuas yog peb ntawm plaub lub hlwb hauv qhov ntau muaj cov ntaub ntawv, cov qauv suav cov feem pua ntawm cov lus teb yog tawm ntawm peb.
Ob ntawm peb cov lus teb yog yog, uas yog sib npaug rau 67%.
Kho qhov feem pua ntawm Yes Lus Teb
Ntxiv cov lus teb yog lossis tsis teb rau ntawm tes E3, uas tau pib tawm ntawm qhov khoob, yuav hloov kho qhov tshwm sim hauv cell E6.
- Yog lo lus teb Yes yog nkag rau hauv E3, qhov tshwm sim hauv E6 hloov mus rau 75%
- Yog lo lus teb Tsis yog nkag rau hauv E3, qhov tshwm sim hauv E6 hloov mus rau 50%
Nrhiav Lwm Yam Tseem Ceeb Nrog Cov Qauv no
Cov qauv no tuaj yeem siv los nrhiav feem pua ntawm txhua tus nqi hauv ntau cov ntaub ntawv. Txhawm rau ua li ntawd, hloov tus nqi nrhiav rau "Yog" hauv COUNTIF muaj nuj nqi. Nco ntsoov, cov ntsiab lus uas tsis yog ntawv tsis tas yuav tsum nyob ib puag ncig los ntawm cov lus hais.