tiksliau 1 uztenka =IF(WEEKDAY(A1;2)=1;B1;0) "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 >>>>>>>>>> >>>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>> >>>>> >>> >>> >>> >> >>