help with countif for two criteria, one of which is a date based on the current date

[ChIpStIcK]

Good evening benevolent board.

I have a diary comprised of tasks listed in column A (eg take dog for a walk, blow nose, go to bed, drop kids at pool) and the dates they are due to be done in column D, in the format 05/10/2013.

A	B	C	D
go to bed			20/07/2013
xxxxxx	¬_¬		guff line, see below
go to bed			25/07/2013
drop kids at pool			25/08/2013
blow nose			10/09/2013

<tbody>
</tbody>

I am trying to create another sheet with a summary of my total tasks each month. So, for example, I need to be able to count the number of times I will need to "blow nose" in a given month relative to the current month.

So,

Tasks	Number of occurences this month	Number of occurences next month	Number of occurnces the month after that
Blow nose	0	0	1
drop kids at pool	0	1	0
go to bed	2	0	0

<tbody>
</tbody>

I've been trying to combine =SUMPRODUCT((Diary!A:A="blow*")*(Diary!D:D="EOMONTH(today()stuff...etc...argh"))
but my feeble brain is getting me nowhere. Help!

Btw, its excel 2010 I'm using and the diary is maybe 2000 lines, lots of them blank or full of other guff in the columns that I need to take tasks and date values from.

 

[Special-K99]

Pivot Table?

 

[ChIpStIcK]

I know nothing of pivot tables but it doesn't seem to want to create one, seemingly because my data is too messy.

 

[Robert Mika]

Maybe:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	go to bed			20/07/2013			Tasks	05/07/2013	31/08/2013	30/09/2013
2	xxxxxx	_		25/07/2013			Blow nose	0	0	1
3	go to bed			25/07/2013			drop kids at pool	0	1	0
4	drop kids at pool			25/08/2013			go to bed	2	0	0
5	blow nose			10/09/2013
6
Sheet3

 

[ChIpStIcK]

Brilliant thanks. Not sure I can quite follow the logic but works beautifully.

Had to amend slightly as when words were in the date column it would give value errors.
If anyone is interested, the finished article is below. I has dates, D has tasks on spreadsheet "Diary". A has the tasks I'm looking for and Row 5 has eomonth(today()+howevermany).
=SUMPRODUCT(--(IFERROR(MONTH(Diary!$I:$I),0)=MONTH(E$5)),--(Diary!$D:$D=$A17))
Thanks again.

 

[Robert Mika]

Have a go with ISNUMBER within the SUMPRODUCT.
It will provide the same solution.