Qhov wikiHow no qhia koj siv "COUNTIF" ua haujlwm hauv Google Ntawv los nrhiav cov lej lossis cov lej hauv cheeb tsam xaiv.
Kauj ruam
Kauj Ruam 1. Mus ntsib https://sheets.google.com ntawm lub vev xaib
Yog tias koj tseem tsis tau kos npe rau hauv koj tus lej Google tseem, ua raws cov lus qhia ntawm lub vijtsam kom nkag mus.
Kauj ruam 2. Nyem rau cov ntawv koj xav kho
Yog tias koj xav tsim daim ntawv nthuav tawm tshiab, nyem lub npov nrog "+" kos npe nyob rau sab laug-laug ntawm daim ntawv.
Kauj Ruam 3. Nyem ob npaug rau kab ntawv khoob uas koj xav siv los tso saib cov suav
Hauv lub npov no, koj yuav tsum nkag mus rau tus lej suav.
Kauj Ruam 4. Ntaus = COUNTIF (rau hauv lub npov
Kauj Ruam 5. Xaiv thaj tsam xaiv nrog cov thawv uas koj xav suav
Nyem thiab luag tus cursor hla thaj chaw xaiv. Tom qab ntawd, qhov kev xaiv yuav raug ntxiv rau "COUNTIF" tus lej.
Koj kuj tseem tuaj yeem xaiv thaj tsam xaiv/ntau yam ntawm tus kheej hauv cov hauv qab no: B2: C4
Kauj Ruam 6. Ntxiv cov qauv tsim nyog tom qab tus lej cim
Txhawm rau suav txhua lub xwmfab uas tau xaiv, tsis hais cov ntaub ntawv twg, hla cov kauj ruam no. Txwv tsis pub, ntaus tus lej, thiab nkag mus rau qhov xav tau ntawm cov lus hais (""). Nov yog qee qhov piv txwv:
- Txhawm rau suav cov thawv hauv qhov xaiv ntau "B2: C4" nrog cov ntaub ntawv/tus lej siab dua "50", sau cov qauv zoo li no = COUNTIF (B2: C4, "> 50"
- Txhawm rau suav cov thawv hauv kab xaiv "B2: C4" nrog cov ntawv "Yog", sau cov qauv zoo li no = COUNTIF (B2: C4, "Yog".
Kauj Ruam 7. Ntaus) qhov kawg ntawm cov mis
Tom qab ntawd, cov mis yuav raug kaw.
- Piv txwv ntawm cov mis tsis muaj cov qauv: = COUNTIF (B2: C4)
- Piv txwv cov mis nrog cov qauv: = COUNTIF (B2: C4, "> 50")
Kauj Ruam 8. Nias Enter los yog Rov qab los.
Cov naj npawb ntawm cov thawv xaiv uas ua tau raws cov qauv (yog tias tsim nyog) yuav muab tso rau hauv lub thawv.
