COUNTIF yobweretsera chiwerengero chokhazikika pamtunda wina
Ntchito COUNTIF imaphatikizapo ntchito IF ndi COUNT zikugwira ntchito mu Google Mapepala. Kuphatikizanaku kumakuthandizani kuti muwerenge kuchuluka kwa nthawi zomwe deta yapadera imapezeka mumaselo osiyanasiyana omwe amakumana ndi chimodzi, chotsatira. Nazi momwe ntchitoyi ikugwirira ntchito:
- IF IF gawo la ntchitoyi limatsimikizira kuti deta ikugwirizana ndi chikhalidwe chanenedwa.
- Gawo LIMODZI la ntchito zonsezi ndi chiwerengero cha maselo omwe amakumana ndi ndondomekoyi.
Ntchito COUNTIF & # 39; s Syntax ndi Arguments
Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakia, olekanitsa okometsa ndi otsutsana . Mawu omasulira a COUNTIF ndi:
= COUNTIF (mtundu, ndondomeko)
Mtunduwu ndi gulu la maselo ntchitoyo ndi kufufuza. Chotsatiracho chimatsimikizira ngati selo lozindikiritsidwa pamakangano osiyanasiyana likuwerengedwa kapena ayi. Zotsatirazi zingakhale:
- Chiwerengero.
- Selo lofotokozera malo a deta mu tsamba, monga B12.
- Mawu, monga 100, "<= 1000" kapena "<>" & B12.
- Deta yamakalata kapena chingwe chachinsinsi, monga "Drapes."
Ngati kukangana kwakukulu kuli ndi manambala:
- Oyerekezera monga : (wamkulu kuposa), <= (osachepera kapena ofanana), kapena <> (osalingana) angagwiritsidwe ntchito m'mawu ake ndipo selo lirilonse liri pazomwe likuyang'anitsitsa kuti liwone ngati likugwirizana .
- Pofuna kufufuza zinthu zofanana, chizindikiro chofanana sichingakhale chophatikizidwa m'mawuwo, ndipo mtengo suyenera kutsekedwa mu zizindikiro za quotation. Mwachitsanzo, 100 ingagwiritsidwe ntchito pamtsutso waukulu mmalo mwa "= 100" ngakhale onse awiri atagwira ntchito.
- Kwa mawu osalingana omwe samaphatikizapo mafotokozedwe a selo, mawu onsewa ayenera kutsekedwa mu zizindikiro zamagwiridwe , monga "<= 1000"
- Kwa mafotokozedwe pogwiritsa ntchito mafananidwe oyerekeza ndi mafotokozedwe a selo, mafotokozedwe a selo saloledwa muzolemba zamagwiridwe, monga "<>" & B12 kapena "<=" & C12.
- Kwa mafotokozedwe pogwiritsa ntchito mafananidwe oyerekeza ndi mawonekedwe a selo, wogwiritsira ntchitoyo amagwirizanitsidwa ndi selo pogwiritsa ntchito ampersand ( & ), omwe ndi chiyanjano cha Excel ndi Google Sheets, monga "<>" & B12 kapena "<=" & C12.
Ngati mkangano wamtundu uli ndi deta yolemba:
- Zingwe zolembera ziyenera kutsekedwa mu zizindikiro zamagwiridwe, monga "drapes".
- Zingwe zolemba zingakhale nazo ? ndi * zilembo zamtunduwu kuti zifanane ndi (() kapena angapo (*) otchulidwa.
- Kuti mufanane ndi chenicheni? kapena *, kutsogolo kwa malembawa ndi tilde monga ~? ndi ~ *.
COUNTIF Zitsanzo za Ntchito
Monga momwe chikuwonetsedwera mu chithunzi chotsatira ndemanga iyi, COUNTIF ntchito imagwiritsidwa ntchito kupeza chiwerengero cha maselo a deta mu gawo A zomwe zikugwirizana ndi zofunikira zosiyanasiyana. Zotsatira za COUNTIF zowonongeka kwazomwe zikuwonetsedwa mu ndondomeko B ndipo mawonekedwe omwewo amasonyezedwa m'mbali C.
- Mizere isanu yoyamba ya chitsanzoyi ikhale ndi deta yolemba pazokambirana ya ntchitoyo ndipo gwiritsani ntchito maselo A2 kuti A6 pazokambirana.
- Mizere isanu isanu ndi iwiri ili ndi chiwerengero cha chiwerengero cha kutsutsana kwapadera.
Kulowa Ntchito COUNT
Mapepala a Google samagwiritsa ntchito bokosi la dialogso kuti alowe mmaganizo a ntchito monga momwe mumapezera mu Excel. M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo. Mndandanda uli m'munsiyi umalowa mu COUNTIF ntchito ndi zifukwa zake zomwe ziri mu selo B11 la chithunzi chachitsanzo. Mu selo ili, COUNTIF ikufufuza ma A7 mpaka A11 chifukwa cha manambala omwe sali oposa 100,000.
Kulowa ntchito COUNTIF ndi zifukwa zake monga momwe zasonyezedwera mu selo B11 la fano:
- Dinani pa selo B11 kuti mupange selo yogwira ntchito . Izi ndi zomwe zotsatira za COUNTIF ntchito zidzawonetsedwa.
- Lembani chizindikiro chofanana ( = ) chotsatira ndi dzina la ntchito yoyang'anira.
- Pamene mukuyimira, bokosi lopangira mothandizilo likuwoneka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata C.
- Pamene dzina COUNTIF likupezeka m'bokosilo, lowetsani mu Enter key pa kibokosilo kuti mulowetse dzina la ntchito ndi kutsegula mzere wozungulira mu selo B11.
- Sungani maselo A7 kuti A11 muwaphatikize ngati kukangana kwa ntchito.
- Lembani comma kuti mukhale olekanitsa pakati pa zosiyana ndi zotsutsana.
- Pambuyo pake, lembani mawu akuti "<=" & C12 kuti aloĊµe monga kutsutsana kwapadera.
- Lembani mzere wa ku Enter pa khididiyi kuti mulowetse mzere womaliza ndikukwaniritsa ntchitoyo.
- Yankho lachinai liyenera kuoneka mu selo B11 popeza maselo onse anayi mu mtsutso wochuluka ali ndi manambala osachepera kapena ofanana ndi 100,000.
- Mukasindikiza pa selo B11 , ndondomeko yomaliza = chilolezo (A7: A10, "<=" & C12 chikuwoneka mu barra ya fomu pamwamba pa tsamba .