View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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?