# Help with SumProduct and dates

#### Rowey

##### Board Regular
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.

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Try

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

Last edited:
Great thanks will let you know how I get on.

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

Replies
3
Views
56
Replies
9
Views
219
Replies
3
Views
133
Replies
5
Views
232
Replies
3
Views
278

1,202,975
Messages
6,052,868
Members
444,606
Latest member
rwmhr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back