Zamkatimu
Nthawi zambiri, mukamagwira ntchito ku Excel, muyenera kuwerengera kuchuluka kwa ma cell patsamba. Awa akhoza kukhala opanda kanthu kapena odzaza maselo okhala ndi manambala okha, ndipo nthawi zina, zomwe zili mkati mwake ziyenera kukwaniritsa zofunikira zina. Mu phunziro ili, tiwona mwatsatanetsatane ntchito ziwiri zazikulu za Excel powerengera deta - ZAKE и COUNTIF, komanso kudziwana ndi anthu omwe satchuka kwambiri - SCHETZ, COUNTBLAN и COUNTIFS.
CHEKANI()
ntchito zowerengera ZAKE imawerengera kuchuluka kwa ma cell omwe ali ndi manambala okha. Mwachitsanzo, pachithunzi chomwe chili pansipa, tawerengera kuchuluka kwa ma cell omwe ali ndi manambala onse:
Muchitsanzo chotsatirachi, ma cell awiri osiyanasiyana amakhala ndi mawu. Monga mukuonera, ntchito ZAKE amawanyalanyaza.
Koma maselo okhala ndi tsiku ndi nthawi amaganiziridwa:
ntchito ZAKE amatha kuwerengera kuchuluka kwa maselo m'magulu angapo osalumikizana nthawi imodzi:
Ngati mukufuna kuwerengera kuchuluka kwa maselo opanda kanthu mumtundu uliwonse, mutha kugwiritsa ntchito ntchito yowerengera SCHETZ. Maselo okhala ndi mawu, manambala, deti, nthawi, ndi makonda a TRUE kapena FALSE amatengedwa kuti alibe kanthu.
Konzani vuto losiyana, mwachitsanzo, kuwerengera kuchuluka kwa maselo opanda kanthu mu Excel, mutha kugwiritsa ntchito ntchitoyi COUNTBLAN:
COUNTIF ()
ntchito zowerengera COUNTIF limakupatsani mwayi wowerengera ma cell a pepala la Excel pogwiritsa ntchito mitundu yosiyanasiyana. Mwachitsanzo, ndondomeko ili m'munsiyi imabweza chiwerengero cha maselo omwe ali ndi makhalidwe oipa:
Njira yotsatirayi imabweretsa chiwerengero cha maselo omwe mtengo wake ndi waukulu kuposa zomwe zili mu selo A4.
COUNTIF kumakupatsani mwayi wowerengera ma cell omwe ali ndi mawu. Mwachitsanzo, ndondomeko ili m'munsiyi imabweza chiwerengero cha maselo omwe ali ndi mawu oti "zolemba" ndipo alibe mphamvu.
Boolean ntchito chikhalidwe COUNTIF ikhoza kukhala ndi makadi akutchire: * (asterisk) ndi ? (mafunso). Nyenyezi imayimira nambala iliyonse ya zilembo zosasintha, pomwe funso limayimira chilembo chimodzi chokha.
Mwachitsanzo, kuwerengera chiwerengero cha maselo omwe ali ndi malemba omwe amayamba ndi chilembo Н (zosamva nkhani), mutha kugwiritsa ntchito njira iyi:
Ngati mukufuna kuwerengera kuchuluka kwa maselo omwe ali ndi zilembo zinayi ndendende, gwiritsani ntchito njira iyi:
ntchito COUNTIF amakulolani kugwiritsa ntchito ma formula ngati chikhalidwe. Mwachitsanzo, kuti muwerenge kuchuluka kwa maselo omwe ali ndi zinthu zazikulu kuposa avareji, mutha kugwiritsa ntchito njira iyi:
Ngati chikhalidwe chimodzi sichikukwanira kwa inu, mutha kugwiritsa ntchito ntchito yowerengera nthawi zonse COUNTIFS. Ntchitoyi imakupatsani mwayi wowerengera ma cell mu Excel omwe amakwaniritsa zinthu ziwiri kapena zingapo nthawi imodzi.
Mwachitsanzo, njira yotsatirayi imawerengera maselo omwe mtengo wake ndi waukulu kuposa ziro koma osakwana 50:
ntchito COUNTIFS amalola maselo kuwerengedwa pogwiritsa ntchito chikhalidwe И. Ngati mukufuna kuwerengera kuchuluka ndi chikhalidwe OR, muyenera kugwiritsa ntchito zingapo COUNTIF. Mwachitsanzo, njira yotsatirayi imawerengera maselo omwe amayamba ndi chilembo А kapena ndi kalata К:
Ntchito za Excel powerengera deta ndizothandiza kwambiri ndipo zimatha kukhala zothandiza nthawi iliyonse. Ndikukhulupirira kuti phunziroli lawululira zinsinsi zonse za ntchito kwa inu. ZAKE и COUNTIF, komanso anzawo apamtima - SCHETZ, COUNTBLAN и COUNTIFS. Bwererani kwa ife kawirikawiri. Zabwino zonse kwa inu komanso kuchita bwino pophunzira Excel.
ndi ovo!