Hi and welcome to the forum

See if this is what you want...
=SUMPRODUCT((Shifts!$A$2:$A$53=B3:H3)*Shifts!$B$2:$B$53)