sumif weekday

[nicolas.schimpf@gmail.com]

HI everyone

I am trying to sum numbers of a specific day of the week like:

sumif(a1:a10;"Monday";b1:b10)

a1:a10 contains date jj/mm/yy like 01/01/2006
b1:b10 contains numbers

I did tried to convert the range a1:a10 into weekdays but this did not
work:

sumif(text(a1:a10;"dddd");"monday";b1:b10)

Can you help me with this formula

Many thanks for your help

Nicolas

[Bob Phillips]

=SUMPRODUCT(--(WEEKDAY(A1:A10)=2))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

<nicolas.schimpf@gmail.com> wrote in message
news:1138904703.352093.93100@g14g2000cwa.googlegroups.com...
> HI everyone
>
> I am trying to sum numbers of a specific day of the week like:
>
> sumif(a1:a10;"Monday";b1:b10)
>
> a1:a10 contains date jj/mm/yy like 01/01/2006
> b1:b10 contains numbers
>
> I did tried to convert the range a1:a10 into weekdays but this did not
> work:
>
> sumif(text(a1:a10;"dddd");"monday";b1:b10)
>
> Can you help me with this formula
>
> Many thanks for your help
>
> Nicolas
>

[nicolas.schimpf@gmail.com]

Hi Bob

Sorry I understand where you include the sum of the numbers in
b1:b10???

Thanks

[Bob Phillips]

Sorry, missed that bit

=SUMPRODUCT(--(WEEKDAY(A1:A10)=2),B1:B10)


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

<nicolas.schimpf@gmail.com> wrote in message
news:1138907373.329351.32670@g49g2000cwa.googlegroups.com...
> Hi Bob
>
> Sorry I understand where you include the sum of the numbers in
> b1:b10???
>
> Thanks
>