Google Servers DNS

Nthawi zina, wogwiritsa ntchitoyo amawerengedwa kuti alibe kuwerengera chiwerengero cha zikhulupiliro mukhola, koma kuwerengera nambala yawo. Izi zikutanthauza kuti kuziyika mwachidule, ndikofunikira kuwerengera maselo angapo omwe ali mu gawo lopatsidwa ali ndi ziwerengero zinazake. Mu Excel, pali zida zingapo zomwe zingathetsere vutoli. Taganizirani aliyense payekha.

Onaninso: Momwe mungawerengere chiwerengero cha mizere ku Excel
Momwe mungawerengere chiwerengero cha maselo odzaza mu Excel

Ndondomeko yowerengera zamtengo wapatali m'ndandanda

Malinga ndi zolinga za wogwiritsira ntchito, mu Excel, n'zotheka kuwerengera malingaliro onse mu ndondomeko, deta chabe ndi zomwe zimakwaniritsa chikhalidwe china. Tiyeni tione momwe tingathetsere ntchito zosiyanasiyana.

Njira 1: Chiwonetsero muzenera zadongosolo

Njirayi ndi yophweka ndipo imafuna kuchuluka kwa ntchito. Ikuthandizani kuti muwerenge chiwerengero cha maselo omwe ali ndi data ndi manambala. Mungathe kuchita izi mwachidule poyang'anitsitsa chizindikirochi muzenera.

Kuti muchite ntchitoyi, ingoganizani batani lamanzere ndi kusankha mtundu wonse umene mukufuna kuwerengera. Mutangomaliza kusankhidwa, muzenera, yomwe ili pansi pazenera, pafupi ndi parameter "Zambiri" chiwerengero cha zikhulupiliro zomwe zili muzenera zidzawonetsedwa. Kuwerengera kudzaphatikizapo maselo odzazidwa ndi deta iliyonse (manambala, malemba, tsiku, ndi zina). Zinthu zopanda kanthu zidzanyalanyazidwa powerenga.

Nthawi zina, chizindikiro cha chiwerengero cha machitidwe sichingawonetsedwe mu barre ya udindo. Izi zikutanthauza kuti zikhoza kukhala zolemala. Kuti muwathandize, dinani pomwepa pa bar Menyu ikuwonekera. Ndikofunika kuyika bokosi "Zambiri". Pambuyo pake, chiwerengero cha maselo odzaza ndi deta chidzawonetsedwa muzenera zadongosolo.

Zoipa za njira iyi zikuphatikizapo mfundo yakuti zotsatira zopezeka sizinalembedwe kulikonse. Ndiko kuti, mutangotulutsa zosankhidwazo, zidzatha. Choncho, ngati kuli kotheka, kukonza izo, uyenera kulemba zotsatira zake pamanja. Kuonjezerapo, pogwiritsa ntchito njirayi, mukhoza kuwerengera zokhazokha zomwe zili m'maselo ndipo simungathe kukhazikitsa zikhalidwe zowerengera.

Njira 2: ACCOUNT woyendetsa

Ndi chithandizo cha woyendetsa COUNTmonga momwe zinalili kale, n'zotheka kuwerengera mfundo zonse zomwe zili m'ndandanda. Koma mosiyana ndi ndondomeko yomwe ili ndi chizindikiro cha udindo, njira iyi imapereka mphamvu yowonetsera zotsatira mu gawo losiyana la pepala.

Ntchito yaikulu ya ntchitoyo COUNTzomwe ziri m'gulu la chiwerengero cha ogwira ntchito, ndi chiŵerengero cha chiwerengero cha maselo opanda kanthu. Choncho, tikhoza kusintha mosavuta zosowa zathu, zomwe ndizo, kuwerengera magawo omwe ali ndi deta. Chidule cha ntchitoyi ndi ichi:

= COUNTA (value1; value2; ...)

Zonsezi, wogwira ntchito akhoza kukhala ndi zokhudzana ndi gulu lonse la 255. "Phindu". Zokambirana ziri chabe maumboni a maselo kapena mndandanda momwe mungadziŵire ziyeso.

  1. Sankhani zomwe zili pa pepala, zomwe zotsatira zake zidzasonyezedwe. Dinani pazithunzi "Ikani ntchito"yomwe ili kumanzere kwa bar.
  2. Kotero ife tinayitana Mlaliki Wachipangizo. Pitani ku gawo "Zotsatira" ndipo sankhani dzina "SUNGANI". Pambuyo pake, dinani pa batani. "Chabwino" pansi pazenera ili.
  3. Timapita ku zenera zotsutsana. COUNT. Lili ndi minda yowonjezera yotsutsana. Mofanana ndi chiwerengero cha zifukwa, amatha kupeza mphamvu za ma unit 255. Koma kuti tithetse ntchitoyi patsogolo pathu, munda umodzi ndi wokwanira Chofunika1 ". Tikaika mtolo mkati mwake ndipo pambuyo pake ndi batani lamanzere lomwe likugwiritsidwa ntchito, sankhani ndondomeko pa pepala, zomwe mukufuna kuziwerengera. Pambuyo pazigawo zowonjezera zazomwe zikuwonetsedwa m'munda, dinani pa batani "Chabwino" pansi pazenera zotsutsana.
  4. Pulogalamuyi ikulingalira ndi kuwonetsera chiwerengero cha zinthu zonse (zolemba ndi zolemba) zomwe zili m'ndondomeko yachindunji mu selo yomwe tinasankha mu sitepe yoyamba ya malangizo awa.

Monga momwe mukuonera, mosiyana ndi njira yapitayi, njirayi ikupereka kuti asonyeze zotsatirapo pazomwe zimakhala pa pepala ndi kusungika kwake komweko. Koma mwatsoka, ntchitoyi COUNT komabe salola kuti zikhazikitse zofunikira kuti zisankhidwe.

Phunziro: Wofalitsa Wothandizira ku Excel

Njira 3: ACCOUNT woyendetsa

Ndi chithandizo cha woyendetsa ACCOUNT N'zotheka kuwerengera chiwerengero cha chiwerengero pazomwe mwasankha. Zimanyalanyaza malemba komanso sizikuphatikizidwa mu chiwerengero chachikulu. Ntchitoyi imakhalanso ndi gulu la owerengetsera, monga kale. Ntchito yake ndi kuwerengera maselo mumasankhidwe osiyanasiyana, ndipo mmalo mwathu tiri muzomwe zili ndi zilembo zamtundu. Chidule cha ntchitoyi chiri pafupi chimodzimodzi ndi mawu apitalo:

= COUNT (value1; value2; ...)

Monga mukuonera, mfundo ACCOUNT ndi COUNT chimodzimodzi ndikuyimira zogwirizana ndi maselo kapena mzere. Kusiyana kwa mawu a syntax kumangotanthauza dzina la woyendetsa yekha.

  1. Sankhani chinthucho pa pepala pomwe zotsatira zidzasonyezedwe. Dinani chizindikiro chomwe tachizoloŵera "Ikani ntchito".
  2. Pambuyo poyambitsa Oyang'anira ntchito sthirani ku gulu kachiwiri "Zotsatira". Kenako sankhani dzina "NKHANI" ndipo dinani pa batani "OK".
  3. Pambuyo pawindo lamakangano la opareshoni layamba ACCOUNTayenera kukhala m'munda wake kuti alowemo. Muwindo ili, monga pawindo la ntchito yapitayi, minda yokwana 255 ikhoza kuperekedwanso, koma, monga nthawi yomaliza, tidzasowa imodzi yokha yomwe imatchedwa Chofunika1 ". Lowetsani m'mundawu mazenera a ndime yomwe tikufunika kugwira. Timachita chimodzimodzi momwe njirayi inkagwiritsidwira ntchitoyi. COUNT: ikani chithunzithunzi m'munda ndipo sankhani ndondomeko ya tebulo. Pambuyo pa adiresi yachitsulo yalowa mu munda, dinani pa batani "Chabwino".
  4. Chotsatiracho chidzawonetsedwa nthawi yomweyo mu selo yomwe tilongosola zomwe zili m'ntchitoyi. Monga mukuonera, pulogalamuyi inkawerengera maselo omwe ali ndi chiwerengero cha chiwerengero. Ma selo opanda kanthu ndi zinthu zomwe zili ndi deta zamtundu sizinalembedwe muwerengedwe.

Phunziro: ACCOUNT ntchito mu Excel

Njira 4: NKHANI YOPHUNZIRA

Mosiyana ndi njira zam'mbuyomu, pogwiritsa ntchito woyendetsa COUNTES ikulolani inu kuti mufotokoze zinthu zomwe zikugwirizana ndi zikhalidwe zomwe zidzalowe muwerengedwe. Maselo ena onse adzanyalanyazidwa.

Woyendetsa COUNTES Zinaphatikizidwanso m'magulu ofufuza a Excel. Ntchito yake yokha ndiyo kuwerengera zinthu zopanda kanthu m'magulu osiyanasiyana, ndipo mmalo mwathu timakhala mu chigawo chomwe chikugwirizana ndi chikhalidwe. Mphatikiti wa ogwira ntchitoyi akusiyana kwambiri ndi ntchito ziwiri zapitazo:

= COUNTERS (muyeso; ndondomeko)

Kutsutsana "Mtundu" imayimira ngati kulumikizana kwa maselo osiyanasiyana, ndipo kwa ife, ku khola.

Kutsutsana "Criterion" ili ndi chikhalidwe chodziwika. Izi zikhoza kukhala nambala yeniyeni kapena malemba, kapena mtengo wofotokozedwa ndi anthu. "zambiri" (>), "zochepa" (<), "osati ofanana" () ndi zina zotero.

Onani kuchuluka kwa maselo omwe ali ndi dzina "Nyama" ali mu ndime yoyamba ya tebulo.

  1. Sankhani chinthu pa pepala, kumene chiwerengero cha deta yomaliza chidzapangidwa. Dinani pazithunzi "Ikani ntchito".
  2. Mu Wizard ntchito pangani kusintha kwa gawolo "Zotsatira"sankhani dzina COUNTES ndipo dinani pa batani "Chabwino".
  3. Amagwira ntchito ntchito mawindo COUNTES. Monga mukuonera, zenera zili ndi minda iwiri yomwe ikugwirizana ndi zokhudzana ndi ntchitoyi.

    Kumunda "Mtundu" mofanana ndi momwe tafotokozera kale, timalowa mu makonzedwe a ndime yoyamba ya tebulo.

    Kumunda "Criterion" tikufunika kukhazikitsa chiwerengero chowerengera. Timalemba mawu kumeneko "Nyama".

    Zokonzekera pamwambazi zitatha, dinani pa batani. "Chabwino".

  4. Wogwira ntchito amachita mawerengero ndipo amasonyeza zotsatira pawindo. Monga mukuonera, chigawo chophatikizidwa mu maselo 63 chili ndi mawu "Nyama".

Tiyeni tisinthe ntchito pang'ono. Tsopano yang'anani chiwerengero cha maselo mu gawo limodzi lomwe liribe mawu "Nyama".

  1. Sankhani selo, komwe tidzasonyezera zotsatira, ndipo momwe tanenera poyambirira timatchula zenera la zotsutsa COUNTES.

    Kumunda "Mtundu" lowetsani makonzedwe a ndime yoyamba yoyamba ya tebulo yomwe idakonzedweratu kale.

    Kumunda "Criterion" lowetsani mawu awa:

    Nyama

    Izi ndizo, chifukwa ichi chimapanga chikhalidwe chakuti timayang'ana zinthu zonse zodzazidwa ndi deta zomwe ziribe mawu "Nyama". Chizindikiro "" amatanthauza ku Excel "osati ofanana".

    Pambuyo polowera makonzedwe awa muwindo lamakani dinani pakani. "Chabwino".

  2. Zotsatira zimapezeka nthawi yomweyo mu selo yoyambirira. Iye akunena kuti pali zinthu 190 mu ndondomeko yowonekera ndi deta yomwe ilibe mawu "Nyama".

Tsopano tiyeni tipange mu ndime yachitatu ya tebuloyi kuwerengera kwa miyezo yonse yomwe imaposa 150.

  1. Sankhani selo kusonyeza zotsatira ndikupanga kusintha ku zenera zotsutsana COUNTES.

    Kumunda "Mtundu" lowetsani makonzedwe a ndime yachitatu ya tebulo lathu.

    Kumunda "Criterion" lembani izi:

    >150

    Izi zikutanthauza kuti pulogalamuyi idzawerengera zokhazokha zomwe zili ndi chiwerengero choposa 150.

    Kenako, monga nthawi zonse, dinani pakani "Chabwino".

  2. Pambuyo kuwerengera, Excel imawonetsa zotsatira mu selo yoyamba. Monga mukuonera, gawolo losankhidwa lili ndi mfundo 82 zomwe zimaposa 150.

Potero, tikuwona kuti mu Excel pali njira zingapo zowerengera chiwerengero cha zikhulupiliro mu column. Kusankha njira inayake kumadalira zolinga za wogwiritsa ntchito. Choncho, chizindikiro pa bar baraloleza kokha kuti chiwone chiwerengero cha zikhalidwe zonse mu khola popanda kukonza zotsatira; ntchito COUNT imapereka mphamvu yokhala nambala yawo mu selo losiyana; woyendetsa ACCOUNT amawerengera zokhazokha zomwe zili ndi data zamtundu; ndi kugwiritsa ntchito ntchitoyo COUNTES Mukhoza kukhazikitsa zovuta zambiri kuti muwerenge zinthu.