aciu labai, zmogau :)


"Squid" <no@email.com> wrote in message 
news:i4vvk6$20c$1@trimpas.omnitel.net...
>
> =SUMPRODUCT((WEEKDAY(A1:A16)=1)*B1:B16)
>
> On 08/24/2010 10:33 AM, bbd wrote:
>> 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
>>>>>
>>>>>
>>>
>>>
>>
>>
>
>