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