G
Guest
In my worksheet, column B contains text and column J contains either 0,1 or
blank. I am trying to count the rows where the text in column B is a specifc
value AND column J is a 0 or a 1 not a blank. I have tried the following:
=SUMPRODUCT(--(B2:B333="Housewares"),--(J2:J333>=0))
but this is counting the blanks as well. Any help would be greatly
appreciated.
blank. I am trying to count the rows where the text in column B is a specifc
value AND column J is a 0 or a 1 not a blank. I have tried the following:
=SUMPRODUCT(--(B2:B333="Housewares"),--(J2:J333>=0))
but this is counting the blanks as well. Any help would be greatly
appreciated.