Auto fill

[dwarek]

Hello Everyone
I have a task to find number of cells which contains particular month. The formula used is =SUMPRODUCT(--MONTH('Sheet1!C2:C1000)=1)) , this formula gives data for empty cells also. For example there is data from C2:C500 but when I select the range C2:C1000 the formula gives value for cells which has data and also counts value for empty cell for the range after 500. Can anyone help to re modify this formula which will ignore the empty cells.
Thanks in advance

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1084503-auto-fill.html#post5211419

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Especially when you had an answer to this 20 minutes before starting this thread.