Count number of times a word appears during a date range

[ashbeigh]

I had the formula and things were working great until I saved over it all and now I have tried, unsuccessfully, to find the formula I used online again. I need help!

I have a list of grants with different names. I need to count the number of times they appear between 9/1/2012 and 12/31/2012 in one row and in another row I need to count the number of times those same grants appears during the month of January, so 1/1/2013 to 1/31/2013. I had tried to recreate the formula I had found with this:

=SUMPRODUCT(--(E3:E127,"MCP"),--(B3:B127,=DATEVALUE>="9/1/2012"),--(B3:B127,=DATEVALUE<="12/31/2012"))

MCP is the grant name.

I am not a huge excel person and need some help! Please help me figure out where my errors are!!!

 

[shg]

=sumproduct(--(e3:e127="mcp"), ...

 

[gsistek]

Welcome to the board!

Try:
=SUMPRODUCT(--(E3:E127="MCP"),--(B3:B127 > =DATE(2012,9,1)),--(B3:B127 < =DATE(2012,12,31)))
or if you are using Excel 2007 or later:
=COUNTIFS(E3:E127,"MCP",B3:B127," > =9/1/2012",B3:B127," < =12/31/2012")

 

[ashbeigh]

Nope. Didn't work And I distinctly remember the first string having a comma.

 

[ashbeigh]

Thanks, gsistek. That one worked.

 

[gsistek]

Glad to help. Thanks for the feedback.