Recurring find a replace

C2;
=SUMPRODUCT((Sheet2!$A$1:$A$15<>"Friday")*(Sheet2!$A$1:$A$15<>"Saturday")*(Sheet2!$B$1:$B$15=B2))
D2;
=SUMPRODUCT(((Sheet2!$A$1:$A$15="Friday")+(Sheet2!$A$1:$A$15="Saturday"))*(Sheet2!$B$1:$B$15=B2))

Then copy both down.