counting specific text in column where date in another column falls between certain dates

[Rusty1970]

Hi,

Am completely baffled with this one. I am trying to identify the number of times specific text appears within a certain financial year period. So if I have 01/07/2011 and 30/06/2012 in D1 and D2 respectively for arguments sake and the data is as an example:

A B
AIA 01/12/2011
TAA 01/12/2011
AIA 01/10/2010

So if I want to find out the number of times "AIA" occurs within the 11/12 financial year it should be 1. My actual data covers over 7000 lines. I will eventually extrapolate this to tell me the occurrence of each specific text code for each financial year but I can't get the base formula right. Help!

 

[venkat1926]

=sumproduct((a1:a3="aia")*(b1:b3>=datevalue("1/1/2011"))*(b1:b3<=datevalue("12/31/2012")))

modify to suit your number of rows.

BETWEEN 1 JAN 2011AND 31 DEC 2012. The dates are to be netered as EXCEL DATES AND NOT AS A STRING. In my computer it is entered as m/d/yyyy. you enter dates according toi your computer