a b c d e
-----------------------------------------------------------------------------
1| 13-Nov-06 20-Nov-06 27-Nov-06 4-Dec-06 11-Dec-06
2| 1 2 3 4 5
3|
4| November, 06
5| 0

I need cell a5 to sum a2:e2 if the month and year on a1:e1 match a4.
I tried =SUMIF(a1:e1,"*Nov*",a2:e2)
and =SUMPRODUCT(--(a1:e1=DATE(YEAR(a4),MONTH(a4),b2:e2)))

Any suggestions?