Momwe Mungawerengere Maselo Pakati Pa Ma Nambala Awiri mu Excel

M'dziko lalikulu la Microsoft Excel, imodzi mwazovuta zomwe timakumana nazo tikamasanthula deta ndi Dziwani kuchuluka kwa ma cell pakati pa manambala awiri. Kusanthula kumeneku kumakhala kothandiza makamaka pazochitika zosiyanasiyana, monga pamene tifunika kuzindikira chiwerengero cha maselo omwe ali mumtundu wina wa manambala.

M’nkhaniyi tikambirana kwambiri momwe mungawerengere ma cell pakati pa manambala awiri⁢ mu Excel, pogwiritsa ntchito zina mwazofala zomwe zimaperekedwa ndi chida champhamvu cha spreadsheet ichi. Kupyolera mu zitsanzo zothandiza komanso zosavuta, tidzakuwongolerani ndondomekoyi kuti muthe kugwiritsa ntchito njirazi pamagulu anu a deta. Kaya ndinu wongoyamba kumene mukuyang'ana kuti muphunzire zanzeru zatsopano, kapena katswiri wodziwa zambiri yemwe akufuna kuwongolera luso lanu, nkhaniyi ili ndi zomwe mungakupatseni.

Tikhala pansi pakufotokozera pang'onopang'ono za momwe mungagwiritsire ntchito ma formula ndi ntchito za Excel ⁤ kuti agwire ntchitoyi. Kuchokera pa ntchito ya COUNTIF mpaka kuphatikizika kovutirapo kwa ma formula, bukhuli lifotokoza njira zingapo kuti zigwirizane ndi zosowa zanu. Chifukwa chake, ngati mwakonzeka kupititsa patsogolo luso lanu la Excel, tiyeni tiyambe kuwerengera ma cell pakati pa manambala awiri.

Kukhazikitsa Njira ya CountIF.SET

Kuti ⁤ kupeza ⁤ kuwerengera ma cell pakati pa manambala awiri mu Excel, titha kugwiritsa ntchito njirayi. Werengani ngati yakhazikitsidwa. Ntchitoyi⁤ imakupatsani mwayi wokhazikitsa njira zingapo kuti ma cell okha omwe amakwaniritsa magawowa amawerengedwa. Ndikofunikira makamaka pazosungira zazikulu, pomwe pamanja zingakhale zovuta komanso zotopetsa kuzindikira ndi kuwerengera ma cell omwe ali mumtundu wofunikira wa manambala.

Ikhoza kukuthandizani:  Kodi ndingagwiritsire ntchito bwanji ntchito yanthawi mu Excel kuwerengera kuchuluka kwa masiku pakati pa masiku awiri?

Ntchito ya ntchitoyi ndi yosavuta. Kwa ife makamaka, kulowa mumtundu wa cell komwe zikhalidwe zimapezedwa, ndikutsatiridwa ndi muyezo womwe uyenera kukhala <= mtengo wapamwamba" ndi muyezo "<=mtengo wochepera". COUNT NGATI YAKHALA Ingowerengera zikhalidwe zomwe zimagwera m'mawerengero omwe takhazikitsa.

Ndikofunika kukumbukira kuti zofunikirazo ziyenera kukhala m'mawu ndikulekanitsidwa ndi ma koma. Nachi chitsanzo cha momwe mungagwiritsire ntchito ntchitoyi.

  • Tiyerekeze kuti tili ndi mndandanda wa manambala omwe ali mugawo A (kuchokera ku A2⁣ mpaka A100).
  • Tiyerekeze kuti tikufuna kuwerengera kuchuluka kwa maselo omwe ali ndi mtengo pakati pa 20 ndi 30.
  • Mu cell yopanda kanthu timayika fomula: =CONTAR.SI.CONJUNTO(A2:A100;">=20",A2:A100;"<=30")
  • Mukasindikiza Enter, Excel idzatipatsa chiwerengero cha maselo omwe akukumana ndi vutoli.

Ndikofunikira kukumbukira kuti kugwiritsa ntchito mankhwalawa COUNT NGATI YAKHALA Sizimangowerengera pakati pa ziwerengero ziwiri za nambala, zingagwiritsidwe ntchito pazinthu zambiri zomwe zimagwiritsidwa ntchito pazigawo zambiri, zomwe zimapangitsa kuti zikhale zothandiza kwambiri komanso zogwiritsidwa ntchito pofufuza deta ndikusintha.

Kutsiliza: Limbikitsani Kuchita Bwino Kwanu mu Excel ndi Ma Cell Accounting Pakati pa Ma Nambala Awiri

Izi ndizofunikira kwa aliyense amene amagwira ntchito ndi manambala ambiri, monga ma accountant, akatswiri azachuma, ndi oyang'anira nkhokwe. Imathandizira kukhathamiritsa njira zowunikira ndikuwongolera bwino mukamagwira ntchito ndi maspredishiti. Pamenepo, Kudziwa kuwerengera ma cell pakati pa manambala awiri mu Excel kumatha kukupulumutsirani maola ambiri a ntchito yamanja ndikuchepetsa mwayi wa zolakwika..

Ikhoza kukuthandizani:  Momwe mungapangire tchati cha pie mu Excel

Itha kukhala yothandiza pamapulogalamu ambiri. Mwachitsanzo, mutha kutsatira maoda omwe ali mumitengo inayake, kapena mutha kuzindikira malonda omwe ali mumtundu wina. Nazi njira zina zomwe mungagwiritsire ntchito mbali yamphamvuyi:

  • Tsimikizirani kuchuluka kwazinthu zomwe zaperekedwa.
  • Dziwani ⁤maselo omwe ali mkati mwa malire ena.
  • Pangani chidule cha ziwerengero ⁢za data.

Mukakulitsa luso lanu la Excel, mudzamvetsetsa momwe lingakhalire lamphamvu. Kudziwa bwino mitundu iyi⁤ yazinthu zapamwamba zitha kutenga nthawi, koma atadziwa bwino, amatha kusanthula deta mwachangu komanso moyenera. Kuphunzira sikusiya mu Excel, koma chinyengo chilichonse chatsopano chomwe mumaphunzira chimakupangitsani kukhala ochita bwino komanso ogwira mtima pantchito yanu. Ndiye bwanji osayesa izi⁤ ndikuwona momwe zingakuthandizireni kuyendetsa bwino ntchito mu Excel?

Kodi nkhaniyi mwapeza zothandiza?

😊 Yes | ☹️Ayi

Kodi mungakonde kutenga nawo gawo pazopereka za PlayStation Portal?

Trucoteca.com Ikondwerera zaka zake 25 🥳🎉

Tengani nawo mbali
Timu ya Trucoteca

Timu ya Trucoteca

Tonsefe timagawana zokonda: masewera a kanema. Takula ndi Trucoteca ndipo ndife onyadira kukhala nawo paulendowu. Tikukondwerera mwachidwi tsiku lokumbukira zaka 25 ndipo tikuyembekezera zaka zambiri tili limodzi.

🎮 Chitani nawo mbali pazopereka zathu zazaka 25