Excel yana da ayyuka da yawa waɗanda za a iya amfani dasu don ƙidaya yawan adadin sel a cikin zaɓin da aka zaɓa wanda ya ƙunshi wani nau'in bayanai.
Ayyukan aikin COUNTA shine ƙidaya yawan adadin sel a cikin kewayon da basu da banza - wato cewa suna dauke da wasu nau'in bayanai kamar rubutu, lambobi, kuskuren halaye, kwanakin, dabarar, ko Boolean dabi'u .
Ayyukan ba su kula da kullun ko komai ba. Idan bayanan bayanan ya ƙara zuwa cikin kullun maras nauyi aikin zai sabunta kwanan nan don haɗawa da ƙarin.
01 na 07
Ƙidaya Cells da ke riƙe da Rubutu ko Sauran Bayanan Bayanan tare da COUNTA
COUNTA Ayyukan Magana da Magana
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Hadawa don aikin COUNTA shine:
= COUNTA (Value1, Value2, ... Value255)
Value1 - (da ake buƙata) Kwayoyin da ko ba tare da bayanan da za a haɗa a cikin ƙidaya ba.
Value2: Value255 - (na zaɓi) ƙarin Kwayoyin da za a hada a cikin ƙidaya. Matsakaicin adadin shigarwar da aka yarda shi ne 255.
Ƙididdigar ƙimar za ta iya ƙunsar:
- tantancewar mutum yana nuna ainihin wuri na bayanan a cikin takardun aiki
- wani kewayon tantancewar salula
- wani layi mai suna
02 na 07
Misali: Ƙididdigar Cells of Data tare da COUNTA
Kamar yadda aka nuna a cikin hoton da ke sama, tantanin halitta yana danganta kwayoyin bakwai da aka haɗa a cikin darajar shawara ga aikin COUNTA.
Shirye-shiryen bayanai daban-daban guda shida da kuma salula guda ɗaya sun hada da kewayon don nuna nau'in bayanai da zasu yi aiki tare da COUNTA.
Kwayoyin da yawa sun ƙunshi siffofi waɗanda aka yi amfani da su don samar da nau'ukan daban-daban, kamar:
- cell A5 - yana amfani da wata hanyar da za ta samar da darajan kuskure # DIV / 0!
- cell A7 - yana amfani da kwatancin dabara don samar da ƙimar Boolean TRUE .
03 of 07
Shigar da Sakamakon COUNTA
Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:
- Rubuta cikakken aikin: = COUNTA (A1: A7) a cikin sashin layi na aiki
- Zabi aikin da kuma muhawara ta amfani da akwatin maganganun COUNTA
Kodayake yana yiwuwa a rubuta aikin gaba ɗaya ta hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu don shigar da muhawarar aiki.
Matakan da ke ƙasa ya rufe shigar da aikin ta amfani da akwatin maganganu.
04 of 07
Ana buɗe akwatin maganganu
Don buɗe akwatin maganganun COUNTA aiki,
- Danna kan salula A8 don sanya shi tantanin aiki - wannan shine inda aikin COUNTA zai kasance
- Danna kan Rubutun shafin shafin rubutun
- Danna kan Ƙarin Ayyuka> Bayar da lissafi don buɗe jerin aikin sauke aikin
- Danna COUNTA a cikin jerin don bude akwatin maganganun
05 of 07
Shigar da Magana ta Magana
- A cikin akwatin maganganu, danna kan Value1 line
- Sanya siffofin A1 zuwa A7 don sun hada da wannan jigon tantanin halitta kamar yadda gardama ke aiki
- Danna Ya yi don kammala aikin kuma rufe akwatin maganganu
- Amsar 6 ya kamata ya bayyana a cell A8 tun lokacin da kawai shida daga cikin bakwai kwayoyin kewayon dauke da bayanai
- Lokacin da ka danna kan sallar A8 da aka kammala daidai = COUNTA (A1: A7) ya bayyana a cikin maɓallin tsari a sama da takardun aiki
06 of 07
Gyara Abubuwan Sakamakon
- Danna kan A4
- Rubuta takaddama ( , )
- Latsa maɓallin shigarwa a kan keyboard
- Amsar a cikin salula A8 ya canza zuwa 7 tun lokacin da cell A4 ba ta da komai
- Share abun ciki na cell A4 kuma amsar a cikin A8 ya kamata ya canza zuwa 6
07 of 07
Dalilai don Amfani da Hanyar Magana Tafiyar
- Maganar maganganun tana kula da haɗin aikin - yana sa ya fi sauƙi don shigar da muhawarar aiki a lokaci daya ba tare da shigar da ƙuƙwalwa ko kalmomi da suke aiki a matsayin raba tsakanin gardama ba.
- Siffofin salula, kamar A2, A3, da A4 za a iya shigar da su ta hanyar yin amfani da ma'ana , wanda ya haɗa da danna kan zaɓuɓɓukan da aka zaɓa tare da linzamin kwamfuta maimakon buga su a cikin. Ba wai kawai yana nuna sauki ba, yana kuma taimaka wajen rage kurakurai a cikin siffofin da aka lalacewa kuskuren salula ba daidai ba.