Excel ili ndi Ntchito zingapo Zowerengera zomwe zingagwiritsidwe ntchito kuwerengera chiwerengero cha maselo m'masankhidwe omwe ali ndi deta yeniyeni.
Ntchito ya COUNTA ndi kuwerenga chiwerengero cha maselo omwe alibe kanthu - kutanthauza kuti ali ndi mtundu wina wa deta monga malemba, manambala, malingaliro olakwika, masiku, ma formula, kapena chikhalidwe cha Boolean .
Ntchitoyi imanyalanyaza zopanda kanthu kapena maselo opanda kanthu. Ngati deta ikuwonjezeredwa ku selo yopanda kanthu, ntchitoyo imangosintha zonse zomwe zikuphatikizapo Kuwonjezera.
01 a 07
Maselo Owerengera Amene Ali ndi Malembo Kapena Mitundu Yina ya Deta ndi COUNTA
COUNTA Funso la Syntax ndi Arguments
Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .
Chidule cha ntchito ya COUNTA ndi:
= COUNTA (Chofunika1, Chofunika2, ... Chofunika255)
Chofunika1 - (chofunika) maselo omwe alibe kapena deta yomwe iyenera kuwerengedwa.
Mtengo2: Chiwerengero255 - (zosankha) maselo owonjezera kuti akhale nawo muwerengero. Chiwerengero chazomwe chiloledwa chikuloledwa ndi 255.
Mtengo wotsutsana ukhoza kukhala nawo:
- maofesi aumwini pamalo a deta mu ofesi yolemba
- malingaliro osiyanasiyana a selo
- dzina lotchuka
02 a 07
Chitsanzo: Kuwerengera Maselo a Data ndi COUNTA
Monga momwe tawonetsera pa chithunzi pamwambapa, mafotokozedwe a maselo ku maselo asanu ndi awiri akuphatikizidwa mu ndondomeko yamtengo wapatali ya ntchito ya COUNTA.
Mitundu sikisi ya deta komanso selo limodzi losaoneka limapanga maulendo kuti asonyeze mitundu ya deta yomwe idzagwira ntchito ndi COUNTA.
Maselo angapo ali ndi mayesero omwe amagwiritsidwa ntchito popanga mitundu yosiyanasiyana ya deta, monga:
- selo A5 - amagwiritsa ntchito fomu kuti apange zolakwika # DIV / 0!
- selo A7 - amagwiritsira ntchito fomu yofananitsa kuti ikhale ndi mphamvu ya Boolean YOONA .
03 a 07
Kulowa mu COUNTA Function
Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:
- Kujambula ntchito yonse: = COUNTA (A1: A7) mu selo lamasewera
- Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito COUNTA ntchito dialog box
Ngakhale kuti n'zotheka kungolemba ntchito yonseyo ndi dzanja, anthu ambiri amavutika kuti agwiritse ntchito bokosilo kuti ayambe kukambirana.
Masitepe omwe ali pansipa alowetsa ntchitoyo pogwiritsa ntchito bokosi.
04 a 07
Kutsegula Bokosi la Zokambirana
Kutsegula COUNTA ntchito dialog box,
- Dinani pa selo A8 kuti mupange selo yogwira ntchito - apa ndi kumene ntchito ya COUNTA idzapezeka
- Dinani pa Fomu tab ya riboni
- Dinani pa Ntchito Zambiri> Chiwerengero kuti mutsegule ntchitoyi
- Dinani pa COUNTA mundandanda kuti mutsegule dialog box
05 a 07
Kulowa Kutsutsana kwa Ntchito
- Mu bokosi la bokosi, dinani pa Value1 mzere
- Onetsetsani maselo A1 mpaka A7 kuti muphatikize mafotokozedwe angapo a maselo monga kutsutsana kwa ntchito
- Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
- Yankho 6 liyenera kuoneka mu selo A8 popeza maselo asanu ndi limodzi okha asanu ndi awiriwo ali ndi deta
- Mukasindikiza pa selo A8 ndondomeko yomaliza = COUNTA (A1: A7) ikuwonekera pa bar barula pamwamba pa tsamba
06 cha 07
Kusintha Zotsatira za Zitsanzo
- Dinani pa selo A4
- Lembani comma ( , )
- Dinani ku key lolowamo pa khibhodi
- Yankho la selo A8 liyenera kusintha mpaka 7 popeza selo A4 silidali lopanda kanthu
- Chotsani zomwe zili mu selo A4 ndi yankho mu selo A8 ziyenera kubwereranso ku 6
07 a 07
Zifukwa zogwiritsira ntchito Njira ya Bokosi la Dialog
- Bukhuli limasamalira mawu ogwira ntchito - kuti zikhale zosavuta kulowa muzokambirana za ntchito imodzi pa nthawi popanda kulowa mu mabakiteriya kapena makasitomala omwe amachititsa kukhala olekanitsa pakati pa zifukwa.
- Malingaliro a magulu, A2, A3, ndi A4 angapangidwe mwachindunji pogwiritsa ntchito posonyeza , zomwe zimaphatikizapo kusindikiza maselo osankhidwa ndi mbewa mmalo mozilemba. Sikuti kumangosonyeza zosavuta, kumathandizanso kuchepetsa zolakwika m'mafomu opangidwa ndi Zolemba zosalunjika za selo.