Nthawi zina ndizofunika kudziwa kuti ndi zingati zomwe zili mu selo. Inde, mungathe kuwerengera pamanja, koma choti muchite ngati pali zinthu zambiri, ndipo chiwerengerocho chiyenera kuchitidwa ndi kusintha zinthu zokhudzana ndi zolinga zina? Tiyeni tiphunzire momwe tingawerengere chiwerengero cha anthu mu Excel.
Kuwerenga malemba
Kwa chiwerengero chowerengera ku Excel, pali ntchito yapadera yotchedwa "DLSTR". Ndi chithandizo chake kuti mutha kufotokozera zizindikiro pazigawo zina za pepala. Pali njira zambiri zomwe mungagwiritsire ntchito.
Njira 1: mawerengedwe owerengeka
Kuti muwerenge anthu onse omwe ali mu selo, gwiritsani ntchito ntchitoyi DLSTR, mwachitsanzo, "mawonekedwe oyera".
- Sankhani pepala lolemba momwe zotsatira zake ziyenera kuwonetsedwa. Dinani pa batani "Lowani ntchito"ili pamwamba pawindo kupita kumanzere kwa bar.
- Yoyambitsa wizara ya ntchito. Kuyang'ana dzina mmenemo DLSTR ndipo dinani pa batani "Chabwino".
- Pambuyo pake ndikutsegula kwawindo lazitsutsano. Ntchitoyi ili ndi kukangana kokha - adiresi ya selo yapadera. Komanso, tiyenera kukumbukira kuti, mosiyana ndi ena ambiri ogwira ntchito, izi sizikuthandizira kulowetsa maumboni angapo kapena maselo. Kumunda "Malembo" lowetsani adiresi ya chinthu chomwe mukufuna kuwerenga malembawo. Mukhoza kuchita mosiyana, zomwe zingakhale zophweka kwa ogwiritsa ntchito. Ikani cholozera m'munda wotsutsana ndipo dinani pa malo omwe mukufunayo pa pepala. Pambuyo pake, adiresi yake idzawonekera m'munda. Deta ikadalowa, dinani pa batani "Chabwino".
- Monga mukuonera, pambuyo pa izi, zotsatira za kuwerengera chiwerengero cha malemba akuwonetsedwa pazenera.
Njira 2: Awerengeni malemba omwe ali m'ndandanda
Kuti muwerenge chiwerengero cha zilembo mumtundu kapena muzinthu zamtundu wina uliwonse, sikofunika kulemba ndondomeko ya selo iliyonse padera.
- Timakhala mu ngodya ya kumanja ya selo ndi ndondomeko. Choyimira chosankhidwa chikuwonekera. Gwirani batani lamanzere la mouse ndi kulitenga lofanana ndi dera limene tikufuna kuwerengera nambala ya malemba.
- Fomuyi imakopedwa pa zonsezi. Zotsatirazo zimapezeka nthawi yomweyo pa pepala.
Phunziro: Momwe mungapangire autocomplete mu Excel
Njira 3: Kuwerengera maselo m'maselo ambiri pogwiritsa ntchito galimoto
Monga tafotokozera pamwambapa, makani otsutsa DLSTR Makonzedwe okha a selo limodzi akhoza kuwonekera. Koma bwanji ngati mukufunikira kuwerengera chiwerengero cha anthu ambiri mwa iwo? Kwa ichi, ndizovuta kugwiritsa ntchito galimoto-sum ntchito.
- Timawerengera chiwerengero cha zilembo pa selo lirilonse, monga momwe tafotokozera m'ndime yapitayi.
- Sankhani mtundu umene malembawo akuwonetsedwa, ndipo dinani pa batani. "Mtengo"ili pa tabu "Kunyumba" mu bokosi lokhalamo Kusintha.
- Pambuyo pake, chiwerengero cha anthu onse m'zinthu zonse chidzawonetsedwa mu selo losiyana ndi kusankha.
Phunziro: Momwe mungawerengere ndalama mu Excel
Njira 4: Kuwerengera zilembo mumaselo ambiri pogwiritsa ntchito ntchitoyi
Mu njira yomwe ili pamwambayi, muyenera kuchita mwamsanga chiwerengero cha chinthu chilichonse payekha ndipo pokhapokha muwerenge chiwerengero cha anthu mumaselo onse. Koma palinso njira yomwe ziwerengero zonse zidzachitika mwa chimodzi mwa iwo. Pankhaniyi, muyenera kugwiritsa ntchito njira yopangira gulu pogwiritsira ntchito operekera SUM.
- Sankhani pepala lopangira zomwe zotsatirazo zidzawonetsedwa. Lowani ndondomeko mmenemo molingana ndi template:
= SUM (DLSTR (selo_address1); DLSTR (selo_address2); ...) - Pambuyo pa ntchitoyi ndi maadiresi a maselo onse, chiwerengero cha zilembo zomwe mukufuna kuwerengera, zalowa, dinani pa batani ENTER. Chiwerengero chonse cha anthuwa chikuwonetsedwa.
Monga momwe mukuonera, pali njira zingapo zoti muwerenge chiwerengero cha malemba mumaselo, ndi chiwerengero cha anthu omwe ali pazinthu zonse. Mu njira iliyonse, opaleshoniyi ikugwiritsidwa ntchito pogwiritsira ntchito ntchitoyi DLSTR.
