On Sat 01/07/06 12:13:00, Bob Phillips wrote:
=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!