Count cells if a range contains month of January and another range is greater than zero

Hello,

I am trying to figure how to count cells if a range contains a date that is in the month of January and another range in the same row is greater than zero.

I have read online that a blank cell will make Excel think that the blank cell is in the month of January. I do have a formula that will count the number of January cells that aren't blank correctly:

=SUMPRODUCT((MONTH('Region'!$C$11:$C$101)=1)*('Region'!$C$11:$C$101 <>""))

I want to add an extra criteria that will count cells in another range that are greater than 1

=SUMPRODUCT((MONTH('Region'!$C$11:$C$101)=1)*('Region'!$C$11:$C$101 <>"")) and ('Region'!$G$11:$G$101>0)

I have no idea how to do this. I have tried many combinations of things and cannot get it to work. I also cannot find anything online that covers this specific scenario.

Any help would be greatly appreciated! Thanks!

Does this work for you?

Formula:

Please Login or Register  to view this content.

Note in your description you state you want to count those in G that are greater than 1, but in your example formula you've put greater than 0.

BSB

This ended up doing it. Thanks for the help! I just had my parentheses in the wrong place and it was making the formula not work.

=SUMPRODUCT((MONTH('Region'!$C$11:$C$101)=1)*('Region'!$C$11:$C$101 <>"")*('Region'!$G$11:$G$101>1))

Happy to help

BSB