Weekday and Sumif
 

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?

Weekday and Sumif
 

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))
--
David Biddulph

"Mike" wrote in message
...
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?

Weekday and Sumif
 

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

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

Weekday and Sumif
 

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

"Mike" wrote:

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?