How to consider only the elements <>0 of the month of January (in Excel)

Question

Here's an example of my problem:

To find all elements for January (including =0 values) I used the following formula which works:

=SUMPRODUCT((MONTH(Table1[DATE])=MONTH(1&P18))*(Table1[DATE]<>""))

where P18 = "GENNAIO" --> (JANUARY)

How do I know the number of records that are >0 and which are ONLY for January (also highlighted in green)?

Is there a formula that automatically returns this result (5)?

Answer 1

This works for me:

=SUM(IF( (MONTH(B3:B17)=1)*(C3:C17>0),1,0))