Woyendetsa ACCOUNT limatanthauzira kuwerengetsera ntchito za Excel. Ntchito yake yaikulu ndi kuwerengera maselo osiyanasiyana omwe ali ndi deta. Tiyeni tiphunzire zochuluka zokhudzana ndi mbali zosiyanasiyana zogwiritsira ntchito ndondomekoyi.
Gwiritsani ntchito ndi woyendetsa ACCOUNT
Ntchito ACCOUNT limatanthawuza gulu lalikulu la owerengetsera, omwe ali ndi maina zana. Ntchitoyi ili pafupi kwambiri ndi ntchito zake. COUNT. Koma, mosiyana ndi phunziro la zokambirana zathu, limaganizira maselo omwe ali ndi deta iliyonse. Woyendetsa ACCOUNTzomwe tidzakhala ndi kukambirana kwakukulu, ziwerengera maselo okhawo omwe ali ndi deta muzinthu zowerengeka.
Kodi ndi deta iti yomwe imatanthawuza kuzinthu? Izi zikutanthawuza momveka bwino nambala yeniyeni, komanso tsiku ndi nthawi ya mawonekedwe. Ziyeso za Boolean ("WOONA", "ZINTHU" ndi zina) ntchito ACCOUNT amalingalira kokha pamene iwo ali ndondomeko yake yomweyo. Ngati atangokhala pamalo a pepala omwe mtsutso umatanthauzira, ndiye kuti woyendetsa sakuwalingalira. Mkhalidwe wofanana ndi maumbidwe oimira manambala, ndiko kuti, pamene manambala amalembedwa m'mavesi kapena kuzunguliridwa ndi anthu ena. Pano, ngati iwo ali kutsutsana mwamsanga, iwo amalowa nawo kuwerengera, ndipo ngati iwo ali chabe pa pepala, ndiye iwo samatero.
Koma poyerekezera ndi zolemba zoyera, zomwe mulibe nambala, kapena zolakwika ("#DEL / 0!", #VALUE! Zomwezo ndizosiyana. Miyezo yotere ikugwira ntchito ACCOUNT sichiwerengera mwanjira iliyonse.
Kuwonjezera pa ntchito ACCOUNT ndi COUNT, kuwerengera chiwerengero cha maselo odzaza omwe akuphatikizapo ogwira ntchito zambiri COUNTES ndi COUNTERSILN. Pothandizidwa ndi machitidwe awa, mukhoza kupanga chiwerengero poganizira zoonjezera zina. Gulu la owerengetsera masewerawa limaperekedwa pa mutu wosiyana.
Phunziro: Momwe mungawerengere chiwerengero cha maselo odzaza mu Excel
Phunziro: Zomwe zimakhala zowerengeka
Njira 1: Wachipangizo Wothandizira
Kwa wosadziwa zambiri, njira yosavuta yowerengera maselo omwe ali ndi manambala akugwiritsa ntchito njirayi ACCOUNT ndi chithandizo cha Oyang'anira ntchito.
- Timangodutsa pa selo lopanda kanthu pa pepala, momwe zotsatira za mawerengedwe zidzawonetsedwa. Timakanikiza batani "Ikani ntchito".
Palinso njira yowonjezera. Oyang'anira ntchito. Kuti muchite izi, mutasankha selo, pitani ku tabu "Maonekedwe". Pa tepiyi mu chida cha zipangizo "Laibulale ya Ntchito" pressani batani "Ikani ntchito".
Pali njira ina, mwinamwake yosavuta, koma nthawi imodzi yomwe imafuna kukumbukira bwino. Sankhani selo pa pepala ndikusindikizira mgwirizano wa makiyi pa kibokosi Shift + F3.
- Pazochitika zonse zitatu, zenera liyamba. Oyang'anira ntchito. Kuti mupite kuzenera zowonjezera zenera "Chiwerengero"kapena "Mndandanda wathunthu wa alfabeti" ndikuyang'ana chinthu "NKHANI". Sankhani ndipo dinani pa batani. "Chabwino".
Ndiponso, zenera zotsutsa zingayambitsidwe mwanjira ina. Sankhani selo kusonyeza zotsatira ndikupita ku tabu "Maonekedwe". Pa kavalo mu gulu la machitidwe "Laibulale ya Ntchito" dinani pa batani "Ntchito Zina". Kuchokera pandandanda womwe ukuwoneka, sungani mtolowo ku malo "Zotsatira". Mu menyu yomwe imatsegula, sankhani chinthucho "NKHANI".
- Fesholo yotsutsana ikuyamba. Chotsutsana chokha cha chigamulochi chikhoza kukhala phindu loyimiridwa ngati chiyanjano kapena cholembedwera mmunda womwewo. Komabe, kuyambira ndi ndondomeko ya Excel 2007, mfundo zoterezi zingakhale zoposa 255. M'masinthidwe oyambirira panali 30 okhawo.
Deta ikhoza kulowetsedwerapo polemba zofunikira kapena makonzedwe a maselo kuchokera ku khibhodi. Koma pazigawo zamakonzedwe zimakhala zophweka kwambiri kungoyika mtolo mmunda ndikusankha selo yoyenera kapena mapepala pa pepala. Ngati pali mitundu yambiri, adiresi yachiwiri akhoza kulowa mmunda "Value2" ndi zina zotero Zotsatirazo zitalowa, dinani pa batani. "Chabwino".
- Chotsatira cha kuwerengera maselo omwe ali ndi chiwerengero cha mawerengedwe mumasankhidwe omwe akusankhidwa adzasonyezedwa kumalo omwe atchulidwa poyamba pa pepala.
Phunziro: Wowonjezera Wogwira Ntchito
Njira 2: Yesani ndi Zowonjezereka
Mu chitsanzo chapamwamba, tinayang'ana pazomwe nkhanizo zimakhudzira mndandanda wa mapepala okhaokha. Tsopano tiyeni tiganizire njira pamene tigwiritsa ntchito mfundo zomwe taziika mwachindunji mumsasawu.
- Ndi njira iliyonse yomwe yasankhidwa mwanjira yoyamba, yendani zitsulo zogwira ntchito ACCOUNT. Kumunda Chofunika1 " tchulani adiresi ya zamtunduwu ndi deta, ndi kumunda "Value2" lozani mawu omveka bwino "WOONA". Timakanikiza batani "Chabwino"kuti achite mawerengedwe.
- Zotsatira zimasonyezedwa kumalo omwe asankhidwa kale. Monga mukuonera, pulogalamuyi inafotokoza chiwerengero cha maselo omwe ali ndi chiwerengero cha chiwerengero ndi kuwonjezera mtengo wina ku chiwerengero chonse, zomwe talemba ndi mawu "WOONA" mumsasa wokangana. Ngati mawuwa analembedwera mu selo, ndipo m'munda ukanakhala wokhudzana ndi icho, ndiye kuti sichidzawonjezeredwa ku chiwerengerocho.
Njira 3: Buku Loyambira Phunziro
Kuwonjezera pa kugwiritsa ntchito Oyang'anira ntchito ndiwindo lamatsutso, wosuta angalowetse mawuwo mwadongosolo pamaselo aliwonse pa pepala kapena mu bar. Koma chifukwa cha ichi muyenera kudziwa chinenero cha woyendetsa. Sizovuta:
= SUM (Mtengo1; Mtengo2; ...)
- Lowani ndondomeko ya mawonekedwe mu selo. ACCOUNT malinga ndi mawu ake ofanana.
- Kuti muwerenge zotsatirazo ndi kuziwonetsera pazenera, dinani pa batani. Lowaniiikidwa pa kambokosi.
Monga mukuonera, zotsatira za zotsatirazi, zotsatira za mawerengedwe amawonetsedwa mu selo losankhidwa. Kwa ogwiritsa ntchito bwino, njira iyi ikhoza kukhala yabwino kwambiri komanso mofulumira. Kuposa omwe apitawo ndi mayitanidwe Oyang'anira ntchito ndi mawindo okangana.
Pali njira zingapo zomwe mungagwiritsire ntchito ntchitoyi. ACCOUNTamene ntchito yake yaikulu ndi kuwerengera maselo okhala ndi chiwerengero cha chiwerengero. Pogwiritsira ntchito ndondomeko yomweyi, mungathe kulemba deta yowonjezera yowwerengera mwachindunji m'munda wamakono kapena mwa kuwalembera mwachindunji mu selo molingana ndi mawu ofanana ndi ochita izi. Kuonjezerapo, pakati pa owerengetsera owerengera pali njira zina zogwiritsira ntchito kuwerengera maselo odzaza omwe ali osankhidwa.
