Weekday and Sumif

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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))
 
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
 
Back
Top