=SUMPRODUCT(--(A2:A5="L"),--(MONTH(B2:B5)=1))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"raf" wrote in message
...
I've got three columns
Column A Column B Column C
L 5-Jan-2006 5,000
M 7-Jan-2006 100
L 1-Feb-2006 10,000
U 24-Mar-2006 10

Alpha code "L" 15,000 Function '=SUMIF(A2:A5,"L".C2:C5)'
Alpha Code "L" in Jan (??? Function)

How do I write the formula to get the alpha code L total for January?