Total production of energy in a specific months

Hi,
I could use a little help with the following:

An Excel sheet with 2 tabs:

Tab #1 is named PRODUCTION_DATA and contains 3 columns of data
B contains 30 dates mixed between 2 calendar months
C contains the 30 dates in B configured to mmm to only show jun or jul (Made for the calculation only)
D contains an energy production output for each of the 30 days in MWh

Tab #2 named PRODUCTION contains a formula that I hope can calculate the total production of energy in a specific months, and in this case it would be July as specified cell C4 where I have a =TODAY() formatted to mmm, I have tried:

{=SUM(IF(PRODUCTION_DATA!$C$4:$C$34=C4;PRODUCTION_DATA!$D$4:$D$34))}

But there are clearly something wrong since the above formula do not recognize any production.

The sheet is attached, please help
Thanks