Wasu lokuta wajibi ne a gano yadda yawancin haruffa suke cikin wani tantanin halitta. Tabbas, zaka iya yin lissafi da hannu, amma abin da za a yi idan akwai abubuwa da dama, kuma za'a kirkiro lissafi tare da sauyawa abun ciki don wasu dalilai? Bari mu koyi yadda za a ƙidaya adadin haruffa a Excel.
Ƙididdigar haruffa
Don halin kirki a Excel, akwai aiki na musamman da ake kira "DLSTR". Yana tare da taimakonsa cewa zaka iya tara alamun a cikin wani takamaiman nau'i na takardar. Akwai hanyoyi da dama don amfani da shi.
Hanyar hanyar 1: ƙididdiga haruffa
Don ƙidaya duk haruffan da ke cikin tantanin halitta, yi amfani da aikin DLSTR, don yin magana, a cikin "nau'i mai tsarki".
- Zaɓi takardar takardar shaidar da aka nuna sakamakon sakamakon. Danna maballin "Shigar da aikin"located a saman taga zuwa gefen hagu na tsari.
- Ya fara aikin mai aiki. Neman sunan a ciki DLSTR kuma danna maballin "Ok".
- Bayan haka shi ne buɗewa na taga na muhawara. Wannan aikin yana da hujja daya kawai - adireshin wani ƙira. Bugu da ƙari, ya kamata a lura cewa, ba kamar sauran masu aiki ba, wannan ba ya goyi bayan shigar da nassoshi zuwa yawancin kwayoyin ko zuwa tsararru ba. A cikin filin "Rubutu" da hannu shigar da adireshin mai taken wanda kake son ƙidaya haruffa. Kuna iya yin shi daban, wanda zai zama sauƙi ga masu amfani. Saita siginan kwamfuta a cikin filin jayayya kuma danna danna kan yankin da kake so a kan takardar. Bayan haka, adireshinsa zai bayyana a filin. Lokacin da aka shigar da bayanai, danna kan maballin "Ok".
- Kamar yadda kake gani, bayan wannan, sakamakon nuna lissafin adadin haruffa an nuna a allon.
Hanyar 2: Ƙididdige haruffa a cikin wani shafi
Don yin lissafin adadin haruffan a cikin wani shafi ko a kowane ɗakunan bayanan, ba lallai ba ne a rubuta takaddama ga kowane tantanin halitta.
- Muna zama a cikin kusurwar dama na tantanin halitta tare da tsari. Alamar alama ce ta bayyana. Riƙe maɓallin linzamin hagu kuma cire shi a layi daya zuwa yankin da muke so mu ƙidaya adadin haruffa.
- Ana kofe wannan tsari a kan dukan jeri. Sakamakon haka nan take a bayyane a kan takardar.
Darasi: Yadda za a yi ba da kyauta a Excel
Hanyar 3: Kira kwayoyin halitta a cikin sel masu yawa ta amfani da jimlar mota
Kamar yadda aka ambata a sama, ƙwararren mai aiki DLSTR kawai ƙunshiyar tantanin halitta ɗaya zai iya bayyana. Amma idan zaka buƙaci lissafin yawan adadin haruffa a yawancin su? Saboda wannan, yana da matukar dace don amfani da aikin haɗin kai.
- Muna lissafin adadin haruffan don kowane tantanin mutum, kamar yadda aka bayyana a cikin version ta baya.
- Zaži kewayon wanda aka nuna adadin haruffa, sa'annan danna maballin. "Adadin"located a cikin shafin "Gida" a cikin akwatin saitunan Ana gyara.
- Bayan haka, yawan adadin haruffa a cikin dukkan abubuwa zasu nuna su a cikin cell da ke kusa da zangon zaɓi.
Darasi: Yadda za a tantance adadin a Excel
Hanyar 4: ƙididdige haruffa a cikin sel da yawa ta amfani da aikin
A cikin hanyar da aka sama, kana buƙatar gaggawa da yin lissafi don kowane ɓangaren daban sannan sai kawai lissafta yawan adadin haruffa a cikin dukkan kwayoyin. Amma akwai kuma wani zaɓi wanda za'a yi dukkan lissafi a cikin ɗaya daga cikin su. A wannan yanayin, kana buƙatar amfani da tsari mai mahimmanci ta amfani da mai aiki SUM.
- Zaɓi takardar takardar shaidar da za a nuna sakamakon. Shigar da dabara a ciki bisa ga samfuri:
= SUM (DLSTR (cell_address1); DLSTR (cell_address2); ...) - Bayan aikin tare da adireshin dukkanin sel, adadin haruffan da kake son ƙidaya, an shigar, danna maɓallin Shigar. Jimlar jimlar haruffan suna nunawa.
Kamar yadda kake gani, akwai hanyoyi da yawa don ƙidaya adadin haruffa a cikin kwayoyin halitta, da kuma yawan adadin haruffan a duk abubuwan da ke cikin kewayon. A cikin kowane zaɓuɓɓuka, wannan aikin yana yin amfani da aikin DLSTR.
