Help with SumProduct and dates

[Rowey]

Hi all, I have a formula that looks at an area on a sheet that contains dates and then counts everytime e.g. that month is January. What I need to do now is alter this slightly so that the dates that it looks like matches not only the month but the year also. Current formula is the one below:

=SUMPRODUCT(--(MONTH('Example'!$T$4:$T$40)=MONTH(B49)))

Have had a play around myself but can't seem to get it to work.

Any help would greatly be appreciated.

 

[VoG]

Try

=SUMPRODUCT(--(MONTH(Example!$T$4:$T$40)=MONTH(B49)),--(YEAR(Example!$T$4:$T$40)=YEAR(B49)))

 

[Rowey]

Great thanks will let you know how I get on.

 

[Rowey]

It worked! Great I don't know what I would do without this site!