Count # items in ColA if blank in ColB
 

I need to count the number of items in ColA that match a certain criteria in
ColA and are blank in ColB. Any ideas?
Thanks.
Nadine

Count # items in ColA if blank in ColB
 

Something like this: =sumproduct((ColA="xxx")*(ColB=""))
--
Max
Singapore
---
"Nadine" wrote:
I need to count the number of items in ColA that match a certain criteria in
ColA and are blank in ColB. Any ideas?
Thanks.
Nadine

Count # items in ColA if blank in ColB
 

Unfortunately I got the result #NUM!. Thanks for trying.

"Max" wrote:

Something like this: =sumproduct((ColA="xxx")*(ColB=""))
--
Max
Singapore
---
"Nadine" wrote:
I need to count the number of items in ColA that match a certain criteria in
ColA and are blank in ColB. Any ideas?
Thanks.
Nadine

Count # items in ColA if blank in ColB
 

"Nadine" wrote:
I need to count the number of items in ColA
that match a certain criteria in ColA and are
blank in ColB.

You do not give sufficient information to provide a solution that you can
enter verbatim. Try something like:

=sumproduct((A1:A100="criteria")*(B1:B100=""))

That assumes a simple criteria based on matching text. If the criteria is
numeric, you would exclude the double-quotes. If the criteria is not a
simple comparison (equal, less than, greater than, etc), you may need to be
more specific if you cannot apply the above paradigm.

Count # items in ColA if blank in ColB
 

I'm assuming you are using XL2003 or earlier. If so, you cannot use whole
column (such as A:A) references within the SUMPRODUCT function... you have
to specify a fixed range and all ranges should be the same length (there are
some exceptions to this, but not for the simple ranges you are using). So,
try something like this...

=SUMPRODUCT((A2:A1000="xxx")*(B2:B1000=""))

--
Rick (MVP - Excel)



"Nadine" wrote in message
...
Unfortunately I got the result #NUM!. Thanks for trying.

"Max" wrote:

Something like this: =sumproduct((ColA="xxx")*(ColB=""))
--
Max
Singapore
---
"Nadine" wrote:
I need to count the number of items in ColA that match a certain
criteria in
ColA and are blank in ColB. Any ideas?
Thanks.
Nadine

Count # items in ColA if blank in ColB
 

ColA is a hardware type and ColB is other data where I want to count the
blanks if they match the criteria in ColA. This is to summarize the rows and
rows of data.

So: How do I count all the laptops in ColA where ColB is blank?

Thanks.


"Joe User" wrote:

"Nadine" wrote:
I need to count the number of items in ColA
that match a certain criteria in ColA and are
blank in ColB.

You do not give sufficient information to provide a solution that you can
enter verbatim. Try something like:

=sumproduct((A1:A100="criteria")*(B1:B100=""))

That assumes a simple criteria based on matching text. If the criteria is
numeric, you would exclude the double-quotes. If the criteria is not a
simple comparison (equal, less than, greater than, etc), you may need to be
more specific if you cannot apply the above paradigm.

Count # items in ColA if blank in ColB
 

Hi,
try

=COUNTIFS(A2:A4,"Laptop",B2:B4,"=")

"Nadine" wrote:

ColA is a hardware type and ColB is other data where I want to count the
blanks if they match the criteria in ColA. This is to summarize the rows and
rows of data.

So: How do I count all the laptops in ColA where ColB is blank?

Thanks.


"Joe User" wrote:

"Nadine" wrote:
I need to count the number of items in ColA
that match a certain criteria in ColA and are
blank in ColB.

You do not give sufficient information to provide a solution that you can
enter verbatim. Try something like:

=sumproduct((A1:A100="criteria")*(B1:B100=""))

That assumes a simple criteria based on matching text. If the criteria is
numeric, you would exclude the double-quotes. If the criteria is not a
simple comparison (equal, less than, greater than, etc), you may need to be
more specific if you cannot apply the above paradigm.

Count # items in ColA if blank in ColB
 

I'm getting #NAME?
Thanks for trying

"Eduardo" wrote:

Hi,
try

=COUNTIFS(A2:A4,"Laptop",B2:B4,"=")

"Nadine" wrote:

ColA is a hardware type and ColB is other data where I want to count the
blanks if they match the criteria in ColA. This is to summarize the rows and
rows of data.

So: How do I count all the laptops in ColA where ColB is blank?

Thanks.


"Joe User" wrote:

"Nadine" wrote:
I need to count the number of items in ColA
that match a certain criteria in ColA and are
blank in ColB.

You do not give sufficient information to provide a solution that you can
enter verbatim. Try something like:

=sumproduct((A1:A100="criteria")*(B1:B100=""))

That assumes a simple criteria based on matching text. If the criteria is
numeric, you would exclude the double-quotes. If the criteria is not a
simple comparison (equal, less than, greater than, etc), you may need to be
more specific if you cannot apply the above paradigm.

Count # items in ColA if blank in ColB
 

Are you using 2007


"Nadine" wrote:

I'm getting #NAME?
Thanks for trying

"Eduardo" wrote:

Hi,
try

=COUNTIFS(A2:A4,"Laptop",B2:B4,"=")

"Nadine" wrote:

ColA is a hardware type and ColB is other data where I want to count the
blanks if they match the criteria in ColA. This is to summarize the rows and
rows of data.

So: How do I count all the laptops in ColA where ColB is blank?

Thanks.


"Joe User" wrote:

"Nadine" wrote:
I need to count the number of items in ColA
that match a certain criteria in ColA and are
blank in ColB.

You do not give sufficient information to provide a solution that you can
enter verbatim. Try something like:

=sumproduct((A1:A100="criteria")*(B1:B100=""))

That assumes a simple criteria based on matching text. If the criteria is
numeric, you would exclude the double-quotes. If the criteria is not a
simple comparison (equal, less than, greater than, etc), you may need to be
more specific if you cannot apply the above paradigm.

Count # items in ColA if blank in ColB
 

Hi,
sorry my mistake I enter something wrong try

=COUNTIFS(A2:A4,"Laptop",B2:B4,"")

"Nadine" wrote:

I'm getting #NAME?
Thanks for trying

"Eduardo" wrote:

Hi,
try

=COUNTIFS(A2:A4,"Laptop",B2:B4,"=")

"Nadine" wrote:

ColA is a hardware type and ColB is other data where I want to count the
blanks if they match the criteria in ColA. This is to summarize the rows and
rows of data.

So: How do I count all the laptops in ColA where ColB is blank?

Thanks.


"Joe User" wrote:

"Nadine" wrote:
I need to count the number of items in ColA
that match a certain criteria in ColA and are
blank in ColB.

You do not give sufficient information to provide a solution that you can
enter verbatim. Try something like:

=sumproduct((A1:A100="criteria")*(B1:B100=""))

That assumes a simple criteria based on matching text. If the criteria is
numeric, you would exclude the double-quotes. If the criteria is not a
simple comparison (equal, less than, greater than, etc), you may need to be
more specific if you cannot apply the above paradigm.

Count # items in ColA if blank in ColB
 

Thank you! It worked.

"Rick Rothstein" wrote:

I'm assuming you are using XL2003 or earlier. If so, you cannot use whole
column (such as A:A) references within the SUMPRODUCT function... you have
to specify a fixed range and all ranges should be the same length (there are
some exceptions to this, but not for the simple ranges you are using). So,
try something like this...

=SUMPRODUCT((A2:A1000="xxx")*(B2:B1000=""))

--
Rick (MVP - Excel)



"Nadine" wrote in message
...
Unfortunately I got the result #NUM!. Thanks for trying.

"Max" wrote:

Something like this: =sumproduct((ColA="xxx")*(ColB=""))
--
Max
Singapore
---
"Nadine" wrote:
I need to count the number of items in ColA that match a certain
criteria in
ColA and are blank in ColB. Any ideas?
Thanks.
Nadine

.

Count # items in ColA if blank in ColB
 

Eduardo, Rich Rothstein gave me the formula to use. Thanks for all your help.

"Eduardo" wrote:


Are you using 2007


"Nadine" wrote:

I'm getting #NAME?
Thanks for trying

"Eduardo" wrote:

Hi,
try

=COUNTIFS(A2:A4,"Laptop",B2:B4,"=")

"Nadine" wrote:

ColA is a hardware type and ColB is other data where I want to count the
blanks if they match the criteria in ColA. This is to summarize the rows and
rows of data.

So: How do I count all the laptops in ColA where ColB is blank?

Thanks.


"Joe User" wrote:

"Nadine" wrote:
I need to count the number of items in ColA
that match a certain criteria in ColA and are
blank in ColB.

You do not give sufficient information to provide a solution that you can
enter verbatim. Try something like:

=sumproduct((A1:A100="criteria")*(B1:B100=""))

That assumes a simple criteria based on matching text. If the criteria is
numeric, you would exclude the double-quotes. If the criteria is not a
simple comparison (equal, less than, greater than, etc), you may need to be
more specific if you cannot apply the above paradigm.