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