Count problems
 

I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
the corresponding B1:B100 cell. Is this possible?

Thank you in advance
--
Sqdncall

Count problems
 

Hi,

=SUMPRODUCT((A1:A100="A")*(B1:B100=""))

Mike

"Sqdncall" wrote:

I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
the corresponding B1:B100 cell. Is this possible?

Thank you in advance
--
Sqdncall

Count problems
 

Thank you Mike ! Works great!
--
Sqdncall


"Mike H" wrote:

Hi,

=SUMPRODUCT((A1:A100="A")*(B1:B100=""))

Mike

"Sqdncall" wrote:

I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
the corresponding B1:B100 cell. Is this possible?

Thank you in advance
--
Sqdncall

Count problems
 

Hi,

If you are using 2007:

=COUNTIFS(A1:A100,"A",B1:B100,"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sqdncall" wrote:

I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
the corresponding B1:B100 cell. Is this possible?

Thank you in advance
--
Sqdncall

Count problems
 

Hi,

In 2003 or 2007 you can also use this

=SUMPRODUCT(--(A1:A8&B1:B8="A"))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sqdncall" wrote:

I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
the corresponding B1:B100 cell. Is this possible?

Thank you in advance
--
Sqdncall

Count problems
 

Shane,

In 2003 or 2007 you can also use this

=SUMPRODUCT(--(A1:A8&B1:B8="A"))

No you can't because it doesn't distinguish between columns the OP wanted
"A" in column A, this would evaluate true for an A in column B and column A
empty

Mike



"Shane Devenshire" wrote:

Hi,

In 2003 or 2007 you can also use this

=SUMPRODUCT(--(A1:A8&B1:B8="A"))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sqdncall" wrote:

I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in
the corresponding B1:B100 cell. Is this possible?

Thank you in advance
--
Sqdncall