in cell B4:

=SUMPRODUCT((B1=$A$9:$A$56)*(B2=$B$9:$B$56)*(B3=$C$9:$C$56)*($D$9:$D$56))

but I like JohnT's better. I haven't used SUMIFS before.