Luke M wrote:
Possible ideas:
=SUMPRODUCT(--(A2:A100="CON"),MONTH(B2:B100=8))

=SUMPRODUCT(--(A2:A100="CON"),--(MONTH(B2:B100)=8))


Would give the count of rows that have CON in column A, and a date in the
month of August. If you need to also limit what year:
=SUMPRODUCT(--(A2:A100="CON"),MONTH(B2:B100=8),--YEAR(B2:B100=2010))

=SUMPRODUCT(--(A2:A100="CON"),--(MONTH(B2:B100)=8),--(YEAR(B2:B100)=2010))


This formula gives count of rows that have CON in column A, and a date
occuring in August 2010.