Qhov wikiHow qhia koj yuav siv li cas COUNTIF muaj nuj nqi hauv Google Ntawv los nrhiav tus lej ntawm cov cell hauv ntau qhov.
Cov kauj ruam
Kauj Ruam 1. Mus rau https://sheets.google.com hauv lub vev xaib
Yog tias koj tseem tsis tau kos npe rau hauv koj tus lej Google, ua raws cov lus qhia ntawm lub vijtsam kom nkag mus tam sim no.
Kauj ruam 2. Nyem rau cov ntawv koj xav kho
Yog tias koj xav tsim daim ntawv tshiab, nyem lub npov nrog "+" nyob rau ntawm kaum sab laug saum toj ntawm daim ntawv.
Kauj Ruam 3. Nyem ob npaug rau ntawm qhov khoob ntawm qhov chaw uas koj xav kom suav kom pom
Nov yog qhov uas koj yuav nkag mus rau tus qauv.
Kauj Ruam 4. Ntaus = COUNTIF (rau hauv xovtooj ntawm tes
Kauj Ruam 5. Xaiv cov cell uas koj xav suav
Txhawm rau ua qhov no, nyem thiab rub tus nas hla txhua qhov. Qhov no ntxiv qhov ntau rau cov lej COUNTIF.
Koj tseem tuaj yeem ntaus qhov ntau ntawm tus kheej hauv hom ntawv hauv qab no: B2: C4
Kauj Ruam 6. Ntxiv cov qauv tsim nyog tom qab tus lej cim
Txhawm rau suav txhua lub xov tooj ntawm tes xaiv tsis hais nws muaj nuj nqis, hla cov kauj ruam no. Txwv tsis pub, ntaus a, thiab tom qab ntawd ntaus cov qauv ntawm cov cim (""). Nov yog qee qhov piv txwv:
- Txhawm rau suav tsuas yog cov cell hauv B2: C4 nrog cov txiaj ntsig ntau dua 50, koj cov mis yuav zoo li = COUNTIF (B2: C4, "> 50"
- Txhawm rau suav tsuas yog cov cell hauv B2: C4 uas hais tias "Yog," koj cov mis yuav zoo li = COUNTIF (B2: C4, "Yog".
Kauj Ruam 7. Ntaus) qhov kawg ntawm cov mis
Qhov no kaw cov mis.
- Piv txwv yam tsis muaj tus qauv: = COUNTIF (B2: C4)
- Piv txwv nrog tus qauv: = COUNTIF (B2: C4, "> 50")
Kauj Ruam 8. Nias ↵ Enter los yog ⏎ Rov qab los.
Suav ntawm xaiv cov cell uas ua tau raws li cov txheej txheem nkag (yog tias tsim nyog) tam sim no tshwm sim hauv cell.