"ramunas" <doobas@gmail.com> wrote in message news:i4vuoh$hu$1@trimpas.omnitel.net... > 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 >>>>>>>>>>> reikmes. >>>>>>>>>>> >>>>>>>>>>> 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 >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>> >>>>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>> >>>