Tema: Re: Excel
Data: 2010-08-24 11:12:17
"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 >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>> >>>>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>> >>>
3Dastronomyagricultureaudioautosautos.audiautos.audioautos.binariesautos.bmwautos.clubautos.fordautos.hondacrxautos.japanautos.mercedesautos.opelautos.sportautos.volvoautos.vwaviaavia.binariesbankcardsbinariesbooksbuildingcinemacommercecomp.hardwarecomp.softwarecomp.lietuvinimascomp.networksculturedarbas.ieskaudarbas.siulaudesigneconomicselectronicsfaunafauna.aquafauna.binariesfishingflorafotofoto.binariesgamesgames.csgames.onlinegsmgurmanaihumourhumour.binariesinternetlawmicrosoftmotomusicmusic.binariesmusic.instrumentsmusic.LT.binariesnavigacijaphppoliticsprogrammingrpgsportstudyingsveikatatalktesttranslationtransportationtraveltravel.binariestvunixvideovideo.binarieswatersportswwwwww.flashpdaautos.supermama.ltmobiledarbasretro.3Dretro.agricultureretro.astronomyretro.audioretro.autosretro.autos.audiretro.autos.audioretro.autos.binariesretro.autos.bmwretro.autos.clubretro.autos.fordretro.autos.hondacrxretro.autos.japanretro.autos.mercedesretro.autos.opelretro.autos.sportretro.autos.supermamaretro.autos.supermama.ltretro.autos.volvoretro.autos.vwretro.aviaretro.avia.binariesretro.bankcardsretro.beosretro.binariesretro.booksretro.buildingretro.cinemaretro.commerceretro.compretro.comp.hardwareretro.comp.lietuvinimasretro.comp.networksretro.comp.softwareretro.cultureretro.darbasretro.darbas.ieskauretro.darbas.siulauretro.designretro.economicsretro.electronicsretro.e-vejasretro.faunaretro.fauna.aquaretro.fauna.binariesretro.fishingretro.floraretro.fotoretro.foto.binariesretro.gamesretro.games.csretro.games.onlineretro.games.rpgretro.genealogijaretro.gsmretro.gurmanairetro.humourretro.humour.binariesretro.internetretro.YZFretro.YZF.nebukretro.YZF.nebuk.netikintisretro.YZF.nebuk.netikintis.bukretro.YZF.nebuk.netikintis.buk.tikintisretro.lawretro.microsoftretro.mobileretro.motoretro.musicretro.music.binariesretro.music.instrumentsretro.music.LTretro.music.LT.binariesretro.navigacijaretro.newsretro.news.taisyklesretro.newuserretro.pdaretro.phpretro.politicsretro.programmingretro.rpgretro.sportretro.studyingretro.sveikataretro.talkretro.translationretro.transportationretro.travelretro.travel.binariesretro.tvretro.unixretro.videoretro.video.binariesretro.watersportsretro.wwwretro.www.flashdiylt.rkm.news.announcelt.rkm.news.newuser