countif using date range

Hi,

I have the following data:

A B
Owned Let Agreed
N 26/11/2010
N 30/11/2010
N 06/12/2010
N 19/12/2010
N 20/12/2010
N 15/01/2011
N 27/01/2011
N 29/01/2011
Y 04/02/2011
N 23/02/2011
Y 01/03/2011
N 11/03/2011
N 28/03/2011
N 16/03/2011
N 30/03/2011
Y 01/05/2011
Y 30/05/2011
Y 08/06/2011
Y 10/06/2011
N 10/06/2011
N 10/06/2011
Y 10/06/2011
Y 10/06/2011
Y 20/06/2011
N 27/06/2011
Y 02/07/2011
N 27/07/2011
Y 10/08/2011
N 16/08/2011
Y 16/08/2011
N 18/08/2011
N 16/08/2011
N 23/08/2011
N 23/08/2011
N 23/08/2011

What I am aiming to do is return the number of properties with lets agreed, depending on whether it is owned or not.

For example, the number of properties which are not owned with lets agreed between 01/01/2011 and 31/01/2011. The answer would be 3.

I have this formula for the date range:
=COUNTIF(B:B,"<=" & DATE(2011,1,31))-COUNTIF(B:B,"<" & DATE(2011,1,1))

I'm just not to sure how to incorporate the other criteria into this formula.

I'd rather this be in 2 formulas, one for owned properties and one for not owned properties.

Any help would be greatly appreciated

Thanks for the replies, the best one for me to use is dilipandey's formula. Thanks anyway to the rest of your responses, they are very much appreciated

I have a similar problem to the original, except now, I have the owned column as before, but instead of a column with dates, I have a column which will either contain the word evict or it will be blank.

What I want to do is to show how many evictions there are, depending on whether the property is owned or not.

I have this formula for the eviction column:

=SUM(IF('Rent Balances'!$H$2:$H$59="Evict",1,0))

This returns how many evictions there are in total. This is not what I want.

I have tried the following formula which isn't right either:

=(SUM(('Rent Balances'!$D$2:$D$59="N")*(SUM(IF('Rent Balances'!$H$2:$H$59="Evict",1,0)))))

What this formula is doing is summing the number of N's and multiplying it by the number of evictions which is 2.

Is there a formula I can use to do what I want it to do?

Thanks

Originally Posted by Søren Larsen

Try this:

For owned: =COUNTIS('Rent Balances'!$H$2:$H$59,"Evict",'Rent Balances'!$D$2:$D$59,"Y")
For not owned: =COUNTIS('Rent Balances'!$H$2:$H$59,"Evict",'Rent Balances'!$D$2:$D$59,"N")

Thanks so much

I started this thread though, the rule says

Don't post a question in the thread of another member.

But in this case, it's the same member. So really, I'm not breaking the rules.