How to count non blank cells with a condition?

[Jay07]

Hi all,

I need to count non blank cells in a column where the date for that ro
(but different column) falls between two dates

For Example...

_______A_________B

1__05/04/2008___TEXT
2__16/10/2011___
3__29/03/2010___
4__09/12/2011___TEXT
5__01/01/2010___TEXT

I need to count all of the non blank cells in column B where the date i
Column A is between or equal to 01/04/2008 & 31/03/2010.

In the example there is only B3 that matches this criteria so th
formula should return 1.

Anyone know how to do that?

Many thanks

Jaso

 

[Jay07]

Thank you Claus, that seems to be what I'm looking for.

It worked fine when applying it to the example I used however when I'v
tried adapting it to the workbook I'm trying to use this in it keep
reading '0' and I've no idea why. Mind having a look and tell me if it'
anything obvious...

=SUMPRODUCT((LEN('PM Orders'!$N$3:$N$65277)>0)*('P
Orders'!$O$3:$O$65277>=DATE(2008,4,1))*('P
Orders'!$O$3:$O$65277<=DATE(2010,3,31)))

The only thing I can think of is that the cells included in the rang
N3:N65277 I'm using an indirect data validation with a drop down list o
options - that shouldn't effect it though should it??

Never mind, the formula worked just fine. What it was is that I ha
changed the time/date system from 1904 to 1907 which then screwed wit
all my dates in column O.

The formula was right though which is why it was showing '0'


Thanks