Just working off DBY's solution, you can use this formula for the weekends.

Formula: copy to clipboard 
=SUMPRODUCT(($C$6:$R$6=1)+($C$6:$R$6=7),$C7:$R7)

Note: This works because the two conditions are mutually exclusive, and summing them only results in 1s and 0s.