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