Nhamba Dhamba muMasero Akasarudzwa neExcel COUNTIF

Iko COUNTIF inobatanidza IF iyo basa uye COUNT basa mu Excel. Uku kubatana kunokubvumira kuti uverenge nhamba dzenguva yakadzama deta inowanikwa muboka rakasarudzwa remasero.

IWO IF chikamu chebasa chinogadzirisa kuti chii chinosangana nedzimwe tsanangudzo uye chikamu che COUNT chinoverenga.

COUNTIF Kushanda Nhanho Nhanho Dzidzo

Iyi dzidzo inoshandisa sarudzo dze data uye COUNTIF basa yekuwana nhamba ye Sales Sales apo ine mirairo inopfuura 250 yegore.

Kutevera matanho ari mumusoro wekudzidziswa mazano pasi apa anokufambisa kuburikidza nekusika nekushandisa COUNTIF basa rakaonekwa mumufananidzo pamusoro apa kuverenga nhamba yekutengesa reps nemirairo inopfuura 250.

01 of 07

Zvidzidzo Misoro

• Kupinda Tutorial Data
• Syntax ya COUNTIF Function
• Kutanga COUNTIF Basa
• Kupinda muRange Argument
• Kupinda muChiteria Argument
• Uye Mhinduro ndeyo ..

02 of 07

Kupinda Tutorial Data

Nhanho yekutanga yekushandisa COUNTIF basa iri muExcel ndeyekuisa data.

Isa data mumasero C1 kusvika E11 epa Excel worksheet sezvinoonekwa mumufananidzo uri pamusoro.

Iko COUNTIF basa uye zvitsva zvinotsvaga (zvinopfuura mairairo 250) zvichawedzerwa kumutsara 12 pasi pe data.

Cherechedza: Zvidzidzo zvekudzidzisa hazvirevi kutora matanho epa pepaji.

Izvi hazvizovhiringidzi nekupedzisa tutori. Tsamba yako yebasa ichaita yakasiyana nezvakaenzanisirwa, asi COUNTIF inokupa mhinduro imwechete.

03 of 07

Syntax ya COUNTIF Function

MuExpcel, syntax yebasa inoreva kurongeka kwebasa uye inosanganisira zita rebasa, mabheketi, uye nharo .

Izwi rechiito che COUNTIF basa nderekuti:

= COUNTIF (Range, Criteria)

IAIFIF Function's Arguments

Nharo dzebasa dzinotaura basa racho mamiriro ezvinhu atinenge tichiedza uye chii chinyorwa chekuverenga kana chiitiko chacho chasangana.

Range - boka remasero basa racho kutsvaga.

Zvinyorwa - kukosha uku kunoenzaniswa nemashoko ari mumasero eRange. Kana mutsara unowanikwa ipapo sero iri muRange inotarwa. Dhiyabhorosi chaiyo kana sero rinoshandiswa kune data rinogona kupinda mukati menyaya iyi.

04 of 07

Kutanga COUNTIF Basa

Kunyange zvazvo zvichikwanisika kungongoronga COUNTIF basa muchikamu mune pepaji , vanhu vazhinji vanoona zviri nyore kushandisa bhokisi rebasa rebasa kuti vapinde basa.

Tutorial Steps

1. Dzvanya pane cell E12 kuti uite iyo inoshandiswa seki . Apa ndipo patinozopinda COUNTIF basa.
2. Dzvanya paMafomu tab yebhoni .
3. Sarudza Mamwe Mabasa> Statistical kubva kubhoni kuti uzarure basa rinoderera pasi.
4. Dzvanya pa COUNTIF mune urongwa kuunza COUNTIF function's dialog box.

Dhenda yatinopinda mumitsetse miviri isina kuvhara mubhokisi rebhokisi ichaita nharo dze COUNTIF basa.

Izvozvi nharo dzinoudza basa kuti chii chatinoedza nacho uye kuti masero anorevei kana chirwere chacho chasangana.

05 of 07

Kupinda muRange Argument

Muchidzidzo ichi tinoda kuwana nhamba ye Sales Sales iyo yakatengesa mairairo anopfuura 250 egore.

Range nharo inotaurira COUNTIF basa iro boka remasero kuti ritsvake apo riri kuedza kuwana tsananguro yakatarwa ye "> 250" .

Tutorial Steps

1. Mubhokisi rebhokisi , tora paRange line.
2. Simbisai masero E3 kusvika E9 pane pepa rekushandisa kuti uise izvi zvinyorwa zvinyorwa sezvenzira yekutsvaga neyo basa.
3. Siya ibhokisi rekuzarura rakazarurirwa kune danho rinotevera mune zvidzidzo.

06 of 07

Kupinda muChiteria Argument

Mhedzisiro yeCriteria inoudza COUNTIF kuti chii chinofanira kuedza kutsvaga kuwana muRange argument.

Kunyange zvazvo data chaiye - yakadai semashoko kana nhamba se "> 250" inogona kuiswa mubhokisi rebhokisi nekuda kwechikonzero ichi zvinowanzova nani kupinda muchikamu chengero mubhokisi rebhokisi, seD12 uye wozoisa data yatinoda kufanana mune iro seki mubasa rekushanda.

Tutorial Steps

1. Dzvanya pamutsara weCriteria mubhokisi rebhokisi.
2. Dzvanya pane sero D12 kuti upinde iyo seferensi inotarisa. Basa racho richatsvaga mararamiro akasarudzwa mudanho rekare kune dhese rinoenderana chero ipi zvayo yakaiswa mune iri sero.
3. Dzvanya OK kuti uvhare bhokisi rebhokisi uye upedze COUNTIF basa.
4. Mhinduro ye zero inofanira kuonekwa muchitokisi E12 - sero patakapinda mubasa - nokuti hatina kuwedzera deta kuCriteria field (D12).

07 of 07

Kuwedzera Mitsva Yokutsvaga

Nhanho yekupedzisira mune zvidzidzo ndeye kuwedzera mvumo yatinoda kuti basa rifanane.

Muchiitiko ichi tinoda nhamba ye Sales Reps nemirairo inopfuura 250 yegore.

Kuti tiite izvi tinopinda > 250 kusvika D12 - sero rakaratidzwa mubasa seine rine mvumo yekuita.

Tutorial Steps

1. Muchitokisi D12 rudzi >
2. Nhamba yechina inofanira kuonekwa muchitokisi E12.
3. Mutsara we "> 250" unosangana mumasero mana mumutsetse E: E4, E5, E8, E9. Saka aya ndiwo chete masero anoverengerwa nebasa racho.
4. Paunenge uchinyora pa cell E12, basa rakakwana
   = COUNTIF (E3: E9, D12) inowanikwa mubhadharo yepamusoro pane pepa pepaji .