Compare two columns, text to date.

A couple of alternatives:

Note: First take the dot away from Jan. and Feb. in C33 and D33...

In Summary!C34:

=SUMPRODUCT(--(Active!$D$4:$D$200=$B34),--(TEXT(Active!$C$4:$C$200,"mmm")=C$33))+SUMPRODUCT(--(Cold!$D$4:$D$200=$B34),--(TEXT(Cold!$C$4:$C$200,"mmm")=C$33))+SUMPRODUCT(--(Wins!$D$4:$D$200=$B34),--(TEXT(Wins!$C$4:$C$200,"mmm")=C$33))+SUMPRODUCT(--(Sold!$D$4:$D$200=$B34),--(TEXT(Sold!$C$4:$C$200,"mmm")=C$33))+SUMPRODUCT(--(Lost!$D$4:$D$200=$B34),--(TEXT(Lost!$C$4:$C$200,"mmm")=C$33))+SUMPRODUCT(--(Dead!$D$4:$D$200=$B34),--(TEXT(Dead!$C$4:$C$200,"mmm")=C$33))

copied down the table and across the columns

A shorter version uses a free Addin function, downloaded from here: Morefunc.xll

=SUMPRODUCT(--(THREED(Active:Dead!$D$4:$D$200)=$B34),--(TEXT(THREED(Active:Dead!$C$4:$C$200),"mmm")=C$33))