Hi Joe,

Provided you input your date in sheet2 cell E1,
then in sheet2 cell B2 formula is :

=SUMPRODUCT(--(Sheet1!$D$2:$D$7=Sheet2!$A2)*--(Sheet1!$C$2:$C$7=LEFT(B$1,1))*--(Sheet1!$B$2:$B$7=Sheet2!$D2)*--(Sheet1!$A$2:$A$7=Sheet2!$E$1))

HTH
Carim