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.

Possibly one way:

=SUMPRODUCT(--(B2:B333="Housewares"),--(J2:J333<""))

HTH,
Paul

--

"karen" wrote in message
...
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.

Another possible way to only look at ones (1) and zeros (0) and exclude
blanks:

=SUMPRODUCT(--(B2:B333="Housewares"),--(J2:J333=0)+(J2:J333=1)-(J2:J333=""))

Regards,
Paul

--

"PCLIVE" wrote in message
...
Possibly one way:

=SUMPRODUCT(--(B2:B333="Housewares"),--(J2:J333<""))

HTH,
Paul

--

"karen" wrote in message
...
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.

Thanks that works - I was so close! Appreciate the help.

"PCLIVE" wrote:

Possibly one way:

=SUMPRODUCT(--(B2:B333="Housewares"),--(J2:J333<""))

HTH,
Paul

--

"karen" wrote in message
...
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.

=SUMPRODUCT((B2:B333="a")*(J2:J333={0,1})*(J2:J333 <""))


"karen" skrev:

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.