T
Tom
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
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