=SUMPRODUCT(--(MONTH(B2:B6000)3),--(MONTH(B2:B6000)<7),--(YEAR(B2:B6000)=2009))


"Vijay DSK" wrote:

Hi all,
Thanks for the previous help.
Now i am struck with another problem hope you guys can help me out.

My issue is i have two columns like
Col1 Col2
Date date
from to
15/04/2008 14/03/2009
.... and so on (Sixty thousand records with different dates)

now i want to filter the data on Month wise for instance...
i want to count all the values under the month Apr-09, May-09, June-09 etc.
Hope i am clear in asking the question.
A speedy help will be greatly appreciated.