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 >>>>>>>>> >>>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>> >>>> >> >> >> > >