Weekday and Sumif

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 23 Dec 2007 08:34 GMT

Hey, I'm wanting to do a sumif formula where the criteria is a certain
weekday. For example:

=SUMIF(A10:A56,WEEKDAY(3),D10:D56)

Which, in theory would return the sum range wherever a tuesday occurs.

It's coming up 0. Anybody know what I could do?

Reply to this Message

David Biddulph - 23 Dec 2007 08:57 GMT

WEEKDAY(3) is calculating for you the day of the week for the date
represented in Excel as the number 3, i.e. 3rd January 1900. That returns a
number 3, which as you realise represents Tuesday. You are not calculating
a day of the week for column A. You have thus set as the SUMIF criterion
the condition that column A should equal 3.

If you want to test for Tuesday dates in column A, try:
=SUMPRODUCT(--(WEEKDAY(A10:A56)=3),D10:D56) or
=SUMPRODUCT((WEEKDAY(A10:A56)=3)*(D10:D56))

Signature

David Biddulph

> Hey, I'm wanting to do a sumif formula where the criteria is a certain
> weekday. For example:
[quoted text clipped - 4 lines]
>
> It's coming up 0. Anybody know what I could do?

Reply to this Message

excelent - 23 Dec 2007 08:59 GMT

=SUMPRODUCT((WEEKDAY(A10:A56)=3)*(D10:D56))

"Mike" skrev:

> Hey, I'm wanting to do a sumif formula where the criteria is a certain
> weekday. For example:
[quoted text clipped - 4 lines]
>
> It's coming up 0. Anybody know what I could do?

Reply to this Message

FloMM2 - 23 Dec 2007 09:01 GMT

Mike,
I got the same answer, "0".
I played around with your formula and came up with this:
=SUMIF(A10:A56,"Tuesday",D10:D56)
The answer I got then was "7".
hth
Dennis

> Hey, I'm wanting to do a sumif formula where the criteria is a certain
> weekday. For example:
[quoted text clipped - 4 lines]
>
> It's coming up 0. Anybody know what I could do?

Reply to this Message