"if" function

[raf]

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?

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[raf]

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

Hi Bob,
How do I get the total to equal to 5,000 for the month of January?
Thanks!

 

[Bob Phillips]

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

Bob Phillips

(remove nothere from email address if mailing direct)

 

[raf]

Hi Bob,
Thanks for the formula! It works great, just what I needed.