Comparing month formula

[st1]

hi all
Been trying to write formula that will check if text"mc20" is pressent in f7-f12 then compare todays month to month in a7-a12 which are in format 12/4/2011 if match add up t7-t12.
The formulas do not like pulling a current month from date.

SUMIFS(T7:T12,F7:F12,"MC20",month(A7:A12),T3)

hope someone can help

 

[njimack]

=sumproduct(--(f7:f12="mc20"),--(month(a7:a12)=month(today()),(t7:t12))

 

[st1]

Tried the formula

but cant seem to get it to work. says there is an error.
have been trying few things and editing formula but to no avail.