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

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

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?