Count Using Multiple Columns
 

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.

Count Using Multiple Columns
 

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.

Count Using Multiple Columns
 

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.

Count Using Multiple Columns
 

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.

Count Using Multiple Columns
 

=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.