Try



=SUMPRODUCT(--(LEFT(nd!$B1:$B10000,2)="BD"),--(nd!$EC1:$EC10000=DATE(2009,10,1)),--(nd!$EC1:$EC10000<DATE(2009,10,31)))


I assume you are using 2007 since you are using B:B but I would refrain from
using that for 2 reasons, your workbook will become very slow and if you
ever save this in 97-2003 format the formula will return a NUM error
when someone with <=2003 opens it

--


Regards,


Peo Sjoblom


"Tom" wrote in message
...
Hello,

I have some data that I need to count based on two criteria.
The tab name for the data is "nd".
The first two characters of column B shows the market ID. I then need it
to
go to column EC and count what dates are in october, november, december
and
2010 and beyond.

This is the formula I've been using, but I can't get the date format
correct:

=SUMPRODUCT(-(LEFT(nd!$B:$B,2)="BD"),-(nd!$EC:$EC=10/1/2009<10/31/2009))

Can someone tell me how I should be entering in the date?

Thanks,
Tom