Ididdige adadin a jere a cikin tebur a Microsoft Excel

Lokacin aiki tare da tebur, sau da yawa dole ku murƙushe maƙallan wani sunan. Za'a iya amfani da sunan takwaranda, sunan ma'aikaci, lambar ɓangare, kwanan wata, da dai sauransu. Sau da yawa waɗannan sunayen sune taken layin sabili da haka, don ƙididdige jimlar sakamakon kowane ɓangaren, ya zama dole a taƙaita abubuwan da ke cikin sel na jere. Wasu lokuta ana ƙara bayanai a cikin layuka don wasu dalilai. Bari mu bincika hanyoyi daban-daban yadda za a iya yin wannan a cikin Excel.

Duba kuma: Yadda za'a kirkiri adadin a Excel

Haɗin darajar kuɗi a jere

Gabaɗaɗa, akwai manyan hanyoyi guda uku don taƙaita dabi'u a cikin kirtani a cikin Excel: ta amfani da tsari mai ma'ana, amfani da ayyuka, da tara kuɗi. A lokaci guda, waɗannan hanyoyin za a iya raba su zuwa ƙarin ƙarin zaɓuɓɓuka na musamman.

Hanyar 1: Tsarin ilimin lissafi

Da farko dai, zamuyi nazari kan yadda ake amfani da dabarun lissafi zaka iya kirga adadin a cikin layin. Bari mu ga yadda wannan hanya take aiki akan takamaiman misali.

Muna da tebur wanda ke nuna kudaden shigar shagunan guda biyar kwanan wata. Sunaye sunaye sunaye, kuma kwanan wata sunayen layi ne. Muna buƙatar lissafta jimlar kudaden shiga na farkon shagon don tsawon lokacin. Don yin wannan, dole ne mu ƙara duk ƙwayoyin layin da ke cikin wannan mafita.

1. Zaɓi sel wanda za'a gama sakamakon lissafin abin da ya ƙare. Mun sanya alama a wurin "=". Hagu-danna akan sel na farko a cikin wannan layi, wanda ya ƙunshi ƙimar lambobi. Kamar yadda kake gani, adireshinsa yana nuna kai tsaye a cikin kashi don nuna adadin. Mun sanya alama "+". Sannan danna kan tantanin na gaba a jere. Ta wannan hanyar muke musanya alamar "+" tare da adireshin sel jikin layin da ke nufin kantin farko.

   A sakamakon haka, a cikin yanayinmu na musamman, an samo wannan tsari mai zuwa:

   = B3 + C3 + D3 + E3 + F3 + G3 + H3

   A zahiri, lokacin amfani da wasu tebur, bayyanarsa zai zama daban.



2. Don nuna jimlar kudaden shiga don fita ta farko, danna maɓallin Shigar a kan keyboard. An nuna sakamakon a cikin tantanin halitta wanda aka samo tsari mai mahimmanci.

Kamar yadda kake gani, wannan hanyar mai sauki ce kuma mai kima, amma tana da gagarumin rabewa daya. Wajibi ne a ciyar da lokaci mai yawa a kan aiwatarwarsa, idan aka kwatanta su da waɗancan zaɓukan waɗanda za mu bincika a ƙasa. Kuma idan akwai layuka da yawa a cikin tebur, to, tsadar kuɗin lokaci zata ƙara ƙaruwa sosai.

Hanyar 2: AutoSum

Hanya mafi sauri don ƙara bayanai a cikin layi shine amfani da tara kuɗi.

1. Zaɓi duk sel tare da lambobi na layin farko. Mun zabi ta hanyar riƙe maɓallin linzamin kwamfuta na hagu. Je zuwa shafin "Gida"danna alamar "Autosum"wacce take akan kintinkiri a cikin akwatin kayan aiki "Gyara".

   

   Wani zabin da za'a kira tara auto shi ne zuwa shafin Tsarin tsari. Akwai a cikin akwatin kayan aiki Laburaren Ma’aikata danna maballin akan kintinkiri "Autosum".

   

   Idan baku son kewaya shafuka kwata-kwata, to, bayan bayyanar layin, zaku iya rubuta hade makullin zafi Alt + =.

2. Duk irin aikin da kuka zaɓa daga cikin alamun da aka ambata a sama, wata lamba za a nuna ta dama ta zaɓin da aka zaɓa. Zai zama jimlar abubuwan layin.

Kamar yadda kake gani, wannan hanyar tana baka damar lissafin adadin a cikin layin da sauri fiye da sigar da ta gabata. Amma kuma yana da aibi. Ya ƙunshi gaskiyar cewa adadin zai nuna kawai zuwa dama na madaidaicin kewayon kwance, kuma ba a wurin da mai amfani yake so ba.

Hanyar 3: aikin SUM

Don shawo kan kasawan hanyoyin guda biyu da ke sama, zaɓi zaɓi ta amfani da aikin ginanniyar aikin Excel da ake kira SAURARA.

Mai aiki SAURARA ya kasance na ƙungiyar Excel ta ayyukan lissafi. Aikin sa shine tara lambobi. Ginin wannan aikin kamar haka:

= SUM (lamba1; lamba2; ...)

Kamar yadda kake gani, hujjojin wannan mai aiki shine lambobi ko adireshin sel wadanda suke cikinsu. Yawan su zai iya zuwa 255.

Bari mu ga yadda zamu iya taƙaita abubuwan a jere ta amfani da wannan ma'aikaci ta amfani da misalin teburinmu.

1. Zaɓi kowane ɓoyayyen tantanin halitta akan takardar inda muke shirin nuna sakamakon ƙididdigar. Idan ana so, zaku iya zaɓar dashi koda akan takaddar littafin. Amma wannan yana faruwa duk ɗaya da wuya, tunda a mafi yawancin lokuta ya fi dacewa a sanya ɗabi'a don al'ada don fitar da sakamako a layi ɗaya da bayanan da aka ƙididdige. Bayan an yi zaɓi, danna kan gunkin "Saka aikin" a hagu na dabarar dabara.



2. Kayan aiki da ake kira Mayan fasalin. Mun wuce shi zuwa ga rukuni "Ilmin lissafi" kuma daga jerin masu aiki da ke buɗe, zaɓi sunan SAURARA. Saika danna maballin "Ok" kasan taga Wizards na Aiki.



3. Ana kunna taga mai aiki na mai aiki SAURARA. Wannan taga zai iya ƙunsar filaye 255, amma don magance matsalarmu, filin kawai kuke buƙata - "Lambar1". Wajibi ne a shigar da ayyukan wannan hanyar, dabi'un da ya kamata a kara su. Don yin wannan, sanya siginan kwamfuta a cikin filin da aka ƙayyade, sannan, riƙe maɓallin linzamin kwamfuta na hagu, zaɓi maɓallin lamba na layin da muke buƙata tare da siginan kwamfuta. Kamar yadda kake gani, adreshin wannan kewayon za'a bayyana shi nan da nan a cikin filin muhawara. Saika danna maballin "Ok".



4. Bayan mun aiwatar da aikin da aka nuna, jimlar abubuwan layin za su nuna nan da nan a cikin tantanin da muka zaba a farkon matakin farko na warware matsalar ta wannan hanyar.

Kamar yadda kake gani, wannan hanyar tana da sauƙin sassauƙa kuma tana da sauri. Gaskiya ne, ba mai hankali ba ne ga duk masu amfani. Don haka, wadanda daga cikinsu ba su da masaniya game da kasancewar su daga tushe daban-daban da wuya su same ta a cikin babbar duba ta kansu da kansu.

Darasi: Ingantaccen fasalin

Hanyar 4: ƙimar jimla a cikin layuka

Amma menene idan kuna buƙatar taƙaita layin ɗaya ko biyu, amma, faɗi, 10, 100, ko ma 1000? Shin yana da mahimmanci ga kowane layi don aiwatar da ayyukan da ke sama daban? Kamar yadda dai itace, ba lallai bane. Don yin wannan, kawai kuna buƙatar kwafa dabarar tattara bayanan zuwa wasu sel waɗanda kuke shirin nuna jimlar sauran layin. Ana iya yin wannan ta amfani da kayan aiki wanda ke ɗauke da sunan alamar mai alamar.

1. Mun ƙara dabi'u a jere na farko na tebur ta kowane hanyoyi da aka bayyana a baya. Mun sanya siginan kwamfuta a cikin ƙananan kusurwar dama na tantanin halitta wanda sakamakon aikin dabara ko aikin da aka nuna. A wannan yanayin, siginan kwamfuta yakamata ya canza kamanninsa ya juya ya zama mai cika alama, wanda yayi kama da ƙaramin giciye. Sannan mun riƙe maɓallin linzamin kwamfuta na hagu kuma mun ja siginar ƙasa a layi ɗaya zuwa sel tare da sunayen layi.



2. Kamar yadda kake gani, duk sel sun cika da bayanai. Wannan shi ne jimlar dabi'u daban daban. An samo wannan sakamakon saboda, ta hanyar tsoho, duk hanyar haɗi a cikin Excel suna da kusanci, ba cikakke ba, kuma lokacin da suke kwafa, suna canza haɗakar su.

Darasi: Yadda ake yin autocomplete a Excel

Kamar yadda kake gani, a cikin Excel akwai manyan hanyoyi guda uku don yin lissafin jimlar abubuwan da suka dace a cikin layin: tsarin ilmin lissafi, tsarin kashe kudi da kuma aikin SUM. Kowane ɗayan waɗannan zaɓuɓɓuka suna da fa'ida da rashin jin daɗinsu. Hanya mafi fahimta ita ce amfani da dabara, mafi saurin zaɓi shine tara kuɗi, kuma mafi yawan duniya shine amfani da mai sarrafa SUM. Kari akan haka, ta amfani da alamar cikewa, zaku iya aiwatar da adadin abubuwan ƙididdiga ta layuka, ɗaya daga cikin hanyoyin ukun da aka lissafa a sama.