Sums for days of the week
=SUM(IF(WEEKDAY(C1:C14)=2,D1:D14)) After typing this, press CTRL+SHIFT+ENTER. Change the red 2 above to any number from 1-7 for each day of the week (1 = Sunday, 7 = Saturday) You can also use a non-array formula, like: =SUMPRODUCT((WEEKDAY(C1:C14)=2)*(D1:D14)) You don't need to press CTRL+SHIFT+ENTER after that formula, just ENTER.