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

[philalethes]

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!

 

[Joe4]

Welcome to the Board!

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

Does this work?

[COLOR=#333333]=SUMPRODUCT((MONTH('Region'!$C$11:$C$101)=1)*('Region'!$C$11:$C$101 <>"") *[/COLOR][B][B]('Region'!$G$11:$G$101>1))[/B][/B]

Note that you said "greater than 1", but had written ">0", so I am not sure which one you really want.

 

[philalethes]

That did it. I swore I tried that before, but I think I just had my parentheses in the wrong the place. Thanks!


Also, I did mean > 0. Sorry for the confusion.

 

[Joe4]

You are welcome!