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