I hv a table of info

Col A = location
Col B = Due Dates

if meet location, then count the number of due dates that fall in Oct or nov
etc....

=SUMPRODUCT(--(A1:A10="location"),--(COUNTIF(b1:b10,DATEDIF("2005/10/1","2005/10/31","yd"))))

Col A Col B
Location Due Dates
USA 10/10/05
Canada 5/1/06
UK 31/12/05
Canada 2/1/06
S. America 30/10/05

Result: oct 05 nov 05 dec 05 jan 06
canada 0 0 0 2
S. America 2 0 0 0