Yuav Paub
- Syntax of COUNTIFS is " =COUNTIFS([cell range], "[condition1]", "[condition2]")."
- Or, xaiv Function (fx) > nrhiav COUNTIFS > siv lub thawv ntawv nkag mus rau ntau yam thiab tej yam kev mob.
- COUNTIFS tshawb nrhiav los ntawm cov xovtooj ntawm tes thiab xa rov qab tus lej ntawm lub sijhawm uas koj tau teev tseg yog qhov tseeb.
Zaj lus no piav qhia yuav ua li cas siv COUNTIF txhawm rau nrhiav pes tsawg zaus cov ntaub ntawv nthuav dav raws li cov xwm txheej tshwj xeeb. Cov lus qhia siv rau Excel 2016 thiab tom qab.
Yuav ua li cas Siv COUNTIFS Function hauv Excel
Lub COUNTIFS muaj nuj nqi tuaj yeem nkag tau manually lossis siv Excel's Formulas menu. Nyob rau hauv ob qho tib si, cov mis thaum kawg yuav zoo ib yam li:
=COUNTIFS(D4:D17, "Yes", E4:E17, ">=5")
Hauv qhov piv txwv no, COUNTIFS muaj nuj nqi tshawb nrhiav los ntawm cov hlwb D4 txog D17, nrhiav cov ntawv Yog thiab dhau ntawm cov hlwb E4-E17 rau cov lej uas sib npaug, lossis siab dua. tsib. Nyob rau hauv rooj plaub uas nws nrhiav pom ob lub ntsiab lus tau ua tiav, nws sau tseg ib qho piv txwv thiab tom qab ntawd suav tag nrho lawv tag nrho, tso tawm pes tsawg zaus ntawm ob qho xwm txheej tau ntsib muaj nyob hauv cov ntaub ntawv.
Ntawm no yog siv cov ntawv qhia zaub mov kom ua tiav txoj haujlwm no.
-
Qhib cov ntaub ntawv Excel uas koj xav siv COUNTIFS muaj nuj nqi hauv thiab xyuas ob zaug tias tag nrho cov ntaub ntawv yog li, thiab qhov twg, nws yuav tsum yog.
Image -
Xaiv lub xovtooj uas koj xav kom COUNTIFS cov txiaj ntsig tshwm sim.
Image -
Xaiv qhov Function zaub mov. Nws yog qhov me me fx logo nyob rau sab sauv-sab laug ntawm lub qhov rais loj, nyob ib sab ntawm tus ntoo khaub lig thiab zuam icons.
Image -
Next to Lossis xaiv ib qeb, siv cov ntawv qhia zaub mov xaiv Tag nrho thiab tom qab ntawd hauv lub thawv tshawb, ntaus COUNTIFS. Xaiv cov txiaj ntsig sib xws (kom xaiv COUNTIFS, tsis yog COUNTIF) thiab xaiv OK.
Image -
In the Function Arguments qhov rai uas tshwm, yog ntaus hauv Criteria_Range1 (thaum pib thiab xaus, sib cais los ntawm txoj hnyuv) lossis nyem / kais thiab luag los ntawm cov hlwb koj xav siv los ua ib feem ntawm kev suav. Hauv peb cov qauv kuaj, uas yog cell D4 txog D17, yog li nws yog cov tswv yim raws li D4:D17
Image -
Type los yog xaiv qhov Cov Cai1 uas koj xav kom COUNTIFS muaj nuj nqi los txiav txim siab. Hauv peb qhov piv txwv, peb xav kom nws xav txog txhua yam Yes tau tshwm sim hauv kab D, yog li peb nkag siab Yes.
Image -
Ua ib yam nrog Criteria_Range2 thiab Criteria2, xaiv cov hlwb thiab sau cov qauv uas koj tab tom nrhiav. Hauv peb qhov piv txwv peb tab tom nrhiav rau cov neeg uas tau mus xyuas Lifewire tsib zaug lossis ntau dua, yog li peb muab tso rau hauv E4:E17 thiab >=5.
Image - Yog tias koj muaj ntau yam ntxiv thiab cov txheej txheem uas koj xav xav, ntxiv rau tib txoj kev.
-
Thaum koj ua tiav, xaiv OK Yog tias koj nkag txhua yam kom raug, koj yuav tsum pom cov txiaj ntsig tshwm hauv lub xov tooj koj tau ua COUNTIF muaj nuj nqi hauv peb qhov piv txwv, qhov Qhov tshwm sim ntawm 6 tshwm sim, vim muaj rau tus neeg hais tias lawv hlub Lifewire, thiab tuaj xyuas nws ntau dua tsib zaug.
Image
Hauv qhov piv txwv no, cov kauj ruam saum toj no tau rov ua dua rau cov neeg uas hais tias lawv tsis hlub Lifewire, tab sis tseem tau mus xyuas tsib lossis ntau dua. Qhov ntawd tau dhau los ua qhov suav qis dua, raws li koj xav tau, tab sis nws tseem yog cov ntaub ntawv nthuav dav tau khaws los ntawm cov ntaub ntawv.
Cov txiaj ntsig no yog qhov pom tseeb me ntsis los ntawm kev saib nrog cov ntaub ntawv txwv tsis pub dhau, tab sis COUNTIFS muaj nuj nqi tuaj yeem siv rau ntawm cov ntaub ntawv nyob ze tsis kawg. Qhov loj dua cov ntaub ntawv yog, qhov muaj txiaj ntsig ntau dua COUNTIFS cov haujlwm tuaj yeem ua rau kev tshuaj xyuas nws.
Yog tias koj tsis xav tau ntau yam thiab cov qauv, koj tuaj yeem siv COUNTIF muaj nuj nqi hloov pauv, uas tsuas yog txwv rau ib qho thiab cov qauv xwb.
COUNTIFS Function yog dab tsi?
Excel tuaj yeem ua tau ntau yam zoo kawg nkaus los ntawm nws tus kheej nrog kev qhia cov ntaub ntawv nkag thiab tshuaj xyuas, tab sis nws tseem muaj txiaj ntsig zoo dua thaum koj siv qhov chaw ntawm nws. Los ntawm kev siv SUM los ua ntau yam kev suav lej, kom tshem tawm cov cim tsis tau luam tawm nrog CLEAN. COUNTIFS ua haujlwm zoo ib yam, tab sis, zoo li COUNTIF muaj nuj nqi, COUNTIFS muaj txiaj ntsig zoo rau kev txheeb xyuas cov ntaub ntawv. Qhov twg COUNTIF saib ntawm ib qho ntawm cov ntaub ntawv thiab cov txheej txheem, txawm li cas los xij, COUNTIFS saib ntau ntawm txhua qhov.
Nws siv cov tswv yim no thiab tso tawm tag nrho raws li qhov koj tab tom nrhiav.
