Sum IF a weekend date

[aadam1215]

I am trying to sum the numbers in column B if the date in column A is a weekend (highlighted in dark blue) This is what I tried but it is not working, can anyone assist me? +SUM(IF(WEEKDAY(B2:B17)>5,C2:C17))

Here is what my info looks like

 

[Joe4]

You have the wrong argument for weekday.
Try:

=SUM(IF(WEEKDAY(B2:B17,2)>5,C2:C17))

If you leave the second argument of WEEKDAY off, the default returns 7 for Saturday and 0 for Sunday.
Option 2 returns 6 for Saturday and 7 for Sunday.
See this link for details, explanations, and the different options: How to use the Excel WEEKDAY function | Exceljet

 

[Strithken]

Source: Sum by weekday | Exceljet

=SUMPRODUCT((WEEKDAY(B2:B17,2) > 5) * C2:C17))