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

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

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

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

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