nu tai vistiek viena reiktu slepti ... tada I C stulpeli returnini su =weekday(A1;2) kelintadienis yra ... o tada jau kur ten tau reikia suma kelintadienio surasyti tai darai SUMIF(C1:C123;1;B1:B123) ..... "ramunas" <doobas@gmail.com> wrote in message news:i4vucc$vkk$1@trimpas.omnitel.net... > ar tau reikia sumuoti tik pirmadienius ar visas dienas atskirai ? > > "bbd" <b@b.d> wrote in message news:i4vu59$v9l$1@trimpas.omnitel.net... >> ? >> >> "ramunas" <doobas@gmail.com> wrote in message >> news:i4vu0o$v34$1@trimpas.omnitel.net... >>> reikia maximum 2 stulpeliu >>> >>> "bbd" <b@b.d> wrote in message news:i4vts7$uqb$1@trimpas.omnitel.net... >>>> t.y. 7 kolonkiu 7 dienom >>>> >>>> "bbd" <b@b.d> wrote in message news:i4vtpt$um5$1@trimpas.omnitel.net... >>>>> nu tai reikies 7 kolonkiu kiekvienai dienai :/ bbiene >>>>> >>>>> >>>>> "VNO" <gabrielmTRINKSITA@takas.lt> wrote in message >>>>> news:i4vtlf$uff$1@trimpas.omnitel.net... >>>>>> tu kaip designeris mokesi padaryti graziai :) >>>>>> paslepsi nereikalingas koloneles ir bus grazu :) >>>>>> >>>>>> >>>>>> VNO >>>>>> "bbd" <b@b.d> wrote in message >>>>>> news:i4vteb$u3e$1@trimpas.omnitel.net... >>>>>>> cia paciam darbe reikia - norisi grazaus sprendimo, jei butu >>>>>>> kitaip - >>>>>>> bbdeciau ir neklausciau >>>>>>> >>>>>>> >>>>>>> "VNO" <gabrielmTRINKSITA@takas.lt> wrote in message >>>>>>> news:i4vt58$tj5$1@trimpas.omnitel.net... >>>>>>>> cia tipo namu darbas koks ar ka? >>>>>>>> kodel per kelias funkcijas netinka? >>>>>>>> >>>>>>>> as daryciau kaip jau sake, weekday vienoje kolonoje, kitoje IF ir >>>>>>>> reiksme, >>>>>>>> o tada jau sumociau pirmadienius pvz >>>>>>>> >>>>>>>> VNO >>>>>>>> "bbd" <b@b.d> wrote in message >>>>>>>> news:i4vsdl$sdi$1@trimpas.omnitel.net... >>>>>>>>> cia tai aisku, bet reikia sprendimo su sumif() :/ >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> "Squid" <no@email.com> wrote in message >>>>>>>>> news:i4vs3b$rqk$1@trimpas.omnitel.net... >>>>>>>>>> arba IF(WEEKDAY(datos_cele)=1; reiksmes_cele;0) ir sumuoti šio >>>>>>>>>> stulpelio >>>>>>>>>> reikšmes. >>>>>>>>>> >>>>>>>>>> On 08/24/2010 10:22 AM, Faktas wrote: >>>>>>>>>>> nu jei paprasciau pvz i sekanti stulpeli irasai: >>>>>>>>>>> =IF(WEEKDAY(A1)=1;1;0) >>>>>>>>>>> jis suteiks reiksme 1, jei priamdienis, ir 0, jei ne. >>>>>>>>>>> tai tada galesi surusiuot, ar atrinkt tik tuos, kur 1. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> "bbd"<b@b.d> wrote in message >>>>>>>>>>> news:i4vr00$q7e$1@trimpas.omnitel.net... >>>>>>>>>>>> Turim lentele: >>>>>>>>>>>> >>>>>>>>>>>> 2010.01.04 5 >>>>>>>>>>>> 2010.02.12 6 >>>>>>>>>>>> 2010.02.06 2 >>>>>>>>>>>> 2010.03.22 31 >>>>>>>>>>>> 2010.04.10 35 >>>>>>>>>>>> 2010.05.05 3 >>>>>>>>>>>> 2010.05.06 4 >>>>>>>>>>>> 2010.05.22 45 >>>>>>>>>>>> 2010.06.10 3 >>>>>>>>>>>> 2010.08.09 56 >>>>>>>>>>>> 2010.08.12 15 >>>>>>>>>>>> 2010.08.16 1 >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> Kaip susumuoti tuos skaicius, kurie yra, tarkim, pirmadieniais >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>> >>>>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >> >>