Kuverenga Mabasa muExcel: Count, Countere, County, County

Mashandiro ekushanda neClof nehuremu hwakawanda muExcel?

Excel ishanduro yakashandiswa kwazvo purogiramu. Izvo zvinodikanwa kuti uverenge kuverenga, kuongororwa kwedata, kufanotaura, kudhirowa mireza yekubhadhara, matafura uye machati, kuverenga mabasa akareruka uye akaoma uye akaoma. Icho chikamu cheMicrosoft Office Suite.

Excel Kuverenga Basa Rinokubatsira zviri nyore iwe kuti uite zvese zvaunoverenga nekuverenga kwako. Iwe unofanirwa kunzwisisa mabasa ebudiriro uye ipapo iwe unogona kuwedzera yako nyanzvi.

Kuverenga muExcel ndeye imwe yeanonyanya kushandiswa mabasa. Zvakawanda zvebhizinesi zvinodiwa zvinoda kuverenga data. Semuenzaniso, kana iwe ukamhanya bhizinesi, ungangoda kuziva kuti vangani vanhu vanoshandisa imwe mhando yeShampoo. Kuti uverenge data iri, iwe unofanirwa kushandisa mafomula yakadai seiverengera, countif, counse, count. ...

Asi zvakadiniko nekushandisa countif uye akawanda mashandiro emamiriro ezvinhu (ane akawanda maitiro) muExcel? Ngatione maitiro ekuita neizvi.

County (Countif)

Counterek inoshandiswa kuverenga huwandu hwemasero mune huwandu hwakavakirwa pane mamwe maitiro. Basic Syntax yeContif:

 = Countif (Range, maitiro)

Mubhokisi renzura, iwe unofanirwa kutaura huwandu umo iwe hwaunoda kuverenga huwandu hwemasero. MuDhiri Dzematare, iwe unofanirwa kudoma maitiro. Maitiro acho anogona kuva nhamba, tambo, mareferensi mareferensi, kana kutaura. Zvichienderana neiyo yakatarwa maitiro, iyo nhamba yekuverenga inoongorora imwe neimwe sero mumhando uye inoverengeka masero ane maitiro.

Semuenzaniso, ngatiti iwe unoda kuverenga huwandu hwevanhu vanogashira muhoro weanodarika zviuru makumi mashanu. Iwe unogona kushandisa iyo countif formula mune huwandu. Zviyero zvinoshanda muExcel

Sezvauri kuona mumufananidzo uri pamusoro, isu tine data revashandi patafura, uye mukoramu yechipiri, tine muhoro unoenderana wemushandi wega wega. Kana iwe uchifanira kuverenga nhamba yevashandi inowana madhora zviuru zvishanu, unogona kushandisa iyo Currenm Fomula nekutsanangura iyo Salam Column Mudamba uye > 5000 mumifananidzo. Iyo nhamba yekuverenga ichaverenga huwandu hwemasero akafanana.

Uchishandisa count

Verenga huwandu hwemasero ane chete mutsara.

Kana iwe uchifanira kuverenga huwandu hwemasero mune huwandu hune tambo (kwete nhamba, mazuva, kana nguva), unogona kushandisa iyo nhamba yekuverengera yakanyorwa neasterisk (*). Syntax:

 = Countif (huwandu, *)

Verenga nhamba yehuwandu husina blank

Kana iwe uchida kuverenga huwandu hwemasero ane mavara, mazuva kana nhamba, unogona kushandisa formula:

 = Kuwanda (renji,)

Iyi formula inoverengera ese maseru echokwadi.

Verenga huwandu hwemasero ane hunhu hwakakura kana hushoma pane imwe kukosha.

Iwe unogona kushandisa yakakura kupfuura chiratidzo mune yekuita ndima yekuverenga masero anodarika imwe kukosha kwakaringana. Semuyenzaniso:

County (Range; "> 10")

Kuti uverenge masero ane tsika dzakashaiwa pane imwe kukosha, iwe unogona kushandisa zvakaderera pane chiratidzo mumunda wekupindirana. Semuyenzaniso:

COUNTIF (range; "<10")

Verenga huwandu hwemasero ane hunhu hwakaenzana kana kuti husina kuenzana nekukosha.

Iwe unogona kushandisa chiratidzo chakaenzana mumunda wekuverenga kuti uverenge masero akaenzana nenhamba. Semuyenzaniso:

Countif (huwandu; "= 10")

Iwe unogona kushandisa iyo isina kuenzana chiratidzo mune yekuita ndima yekuverenga masero ane kukosha haana kuenzana nenhamba. Semuyenzaniso:

County (renji; "10")

County neye akawanda maitiro

Kana paine zvinopfuura rumwe renji uye maitiro, iwe unogona kushandisa iyo nhamba yekuverenga. Izvo zvinoshanda zvakafanana necariff, asi zvinoshandiswa pamwe chete nemaitiro akati wandei.

Iyo syntax ndeye madhiri:

 = Zviyero (range 1, chinongedzo 1, huwandu 2, chinongedzo 2 ..)

Iwe unogona kusarudza akawanda marangi uye shandisa maitiro. Iyo yekupedzisira huwandu icharatidzwa yakavakirwa pane dzakasiyana siyana maitiro.

Kuenderera mberi nemuenzaniso wedu wapfuura, ngatitii isu tinoda kutsanangura kumwe kukura mune corporation. Ngatitiiwo chirevo chekusimudzira ndechekutevera: Mubairo unofanirwa kunge uri pasi pe50,000 rubles, uye kupinda kwemushandi kunofanirwa kunge kuri kupfuura 85%.

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Mune iyo muenzaniso uri pamusoro, tine zita remushandi se data iri muColumn yekutanga, iyo data yemubhadharo mune yechipiri mutsara, uye data rekuenda mukirabhu yechitatu. Iye zvino tava kuverenga nhamba yevashandi vane muhoro wevasingasviki zviuru makumi mashanu zvbras. uye anopfuura 85% kuenda. Sezvo iyo data inotaurwa nezvikamu zviviri zvakasiyana, tinofanira kudoma huwandu hwakakodzera uye tishandise maitiro. Izvi zvinotipa huwandu hwemasero anosangana neese maitiro.

Nekutenderwa, zviyero zvinoshanda uye pfungwa kune dzakasiyana siyana maitiro.

Zviyero zvinodzosera huwandu hwemitsara idzo maseru anoenderana neyeye matsanangurwa maitiro.

Countif neClengof ichashandawo kana masero asina kujairika.

Iwe unogona zvakare kushandisa mavara akakosha senge *, & etc., zvichienderana nezvaunoda.

Iko hakuna kupfupi kwebasa iri. Iwe unofanirwa kuisa fomula uchitanga nechiratidzo chakaenzana, pinda marangi uye maitiro, uye pinda Enter.

(Kana) maitiro muClaterif

Sezvo kuverenga kunoshandisa default uye pfungwa, iwe uchazoda kushandisa imwe nzira yekuita kana kushanda muCloud. Muenzaniso uri pamusoro, kana iwe uchida kuverenga huwandu hwevashandi avo vane muhoro wesiri madhora zviuru zvishanu kana kuti vanopinda vakanyanya kupfuura 85%, isu tinofanirwa kushandisa iyo kana pfungwa pano.

Basic Syntax ye kana Logic muClof:

 = Countif (Range_1, Cradheon_1) + Countif (Range_2, Cradheon_2)

Mumuenzaniso uyu, tiri kushanda neiyo imwechete data yaive yatove yamboshandiswa seyakaenzana muenzaniso pamusoro. Asi pano tiri kushandisa kana kunyora panzvimbo uye (iyo countere inobuda neyakagadziriswa uye logic ndeye 2 ne default; uye iyo yekudzora inobuda neye kana logic ndeye 9).

Pano isu tinowedzera maviri akasiyana akasiyana emabasa kubata akawanda maitiro. Mhedzisiro yekutanga kuverenga (pane iyo danho remari risingasviki madhora zviuru zvishanu) ndeye 2,000 yechipiri kuverenga (ipo pakatarisana ne85%) ndeye 7. Saka, tinogona kuwana pfungwa ye Kana muCancif. Uye cherechedza kuti kuitira kuti uwane mhinduro chaiyo mune ino nyaya, tinoda kudzora huwandu hwevanhu vari vaviri zvikamu.

Kunyange paine akawanda mashandisiro ehuwandu hwehuwandu uye madhiri, aya mabasa ari nyore kudzidza uye kuyeuka. Ini ndapa mimwe mienzaniso yaunogona kuedza zvakananga muMicrosoft Excel. Mushure mekupedza iyi mienzaniso, iwe unogona kugadzira yako wega muenzaniso nekuunganidza data risina kurongeka kubva kuInternet. Paunenge iwe uchinge unonzwisisa kuti counterek inoshanda sei nemaitiro mazhinji, uye maitiro akakwana, unogona kuverenga masero ane chero data!

Maitiro ekufunga zvakawandisa maitiro?

Excel formula yekuverenga maitiro mazhinji: = madhora. Iyo s pakupedzisira inoita kuti zviwedzere uye nenzira inoreva kuti pane akawanda maitiro (2 kana anopfuura).

Muenzaniso nemifananidzo pazasi mune ino dzidzo, iwe uchadzidza chaizvo kushandisa kuverenga muExcel.

Ini ndinoshandisa sei akawanda countif maitiro?

Zvikamu zvinoshanda zvakafanana neCountIF, kunze kwekuti iwe unogona kuwedzera mamwe maitiro, akaparadzaniswa nemakomichi. Heino nhanho-ne-nhanho gwara pamabatiro ekuzviita.

• Nhanho 1: Nyora maitiro kana mamiriro aunoda kuyedza.
• Nhanho yechipiri: Pinda = maka ( uye sarudza iyo iyo iyo yaunoda kuyedza iyo yekutanga nzira).
• Nhanho 3: Isa bvunzo yeiyo nzira.
• Nhanho 4: Sarudza iyo yechipiri yekuverenga huwandu iyo yaunoda kuyedza (inogona kuve yakafanana huwandu zvakare kana chitsva).
• Nhanho 5: Isa bvunzo yeiyo nzira.
• Nhanho 6: Dzokorora mutemo uri pamusoro kakawanda sezvazvinodiwa.
• Nhanho 7: Vhara bracket uye tinya Enter.

Muenzaniso weChibvumirano Nemienzaniso Yakawanda

Sezvauri kuona, chimwe nechimwe chezviyero chinoedzwa, uye Excel inoverenga kuti kangani nguva iyo bvunzo mhedzisiro ndeyechokwadi. Aya ndiwo maitiro ekushandisa Excel kuti uverenge zvikuru maitiro.

Nei usingacheki?

Pane zviitiko zvakawanda kwaungangoda kuverenga kuti kangani kakawanda maitiro akawadziswa. Mune mari, izvi zvinogona kushandiswa kusarudza makambani anoenderana nechero nhoroondo. Sezvineiwo pamusoro, taida kuziva kuti makambani mangani anokwana mimwe yemusika cap kana imwe macapeter ehupfumi. Uchishandisa kana kufunga muCountIF / madhora kunogona kuita kuti zvinyatsogona uye kukuponesa iwe dambudziko rekunyora mafomasi.

Mibvunzo Inowanzo Bvunzwa

Unoshanda sei muExcel?

Kana iwe uchifanira kuverenga huwandu hwemasero mune huwandu hune tambo (kwete nhamba, mazuva, kana nguva), unogona kushandisa iyo nhamba yekuverenga ine maitiro easterisk (*).