dates and text in excel

[Squidgee]

I have a spreadsheet that contains mostly dates and have worked out how to
count them!! the next issue is i have one column with text and would like to
count if in that column and then dates in a month from the next colum.

ie:

Dept Date

CON 23/01/2009
NFT 24/05/2010
CPE
EDC 08/10/2012

so that if con has 2 dates i know how many for a given month (in the future).

Hope that makes sense!! And Thanks guys

 

[Luke M]

Possible ideas:
=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))

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

 

[Glenn]

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.