Weekday and Sumif

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

David Biddulph

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))
 
F

FloMM2

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where to put quotes in a SUMIF formula and when is & used for cell 2
What is wrong with this formula 2
SUMIF & OR 6
Sumif formula 4
Using a SUMIF and Parsing to sum part of a cell 6
Sumif number is greater than a number but less than another number 2
Weekday function Not right 1
Using SumIf and Multiple Conditions 3

Top