I am trying to count number of entries in a column meeting 2 conditions - one
condition being column1 values being >=100% & column2 values = "Text".

I am getting total number of entries meeting Column2="Text" minus
Column1>=100%

--
Alisaheb

If your data set is as follows:

A B
100% empty
56% yes
107% no
103% text
75% text

if your intended total is 5 then use the formuale as follows:
=SUM(COUNTIF(A:A,">=100%"),COUNTIF(B:B,"TEXT"))

jatman


"alisaheb" wrote:

> I am trying to count number of entries in a column meeting 2 conditions - one
> condition being column1 values being >=100% & column2 values = "Text".
>
> I am getting total number of entries meeting Column2="Text" minus
> Column1>=100%
>
> --
> Alisaheb

=SUMPRODUCT(--(A2:A200>=100%),--(B2:B200="TEXT"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"alisaheb" <(E-Mail Removed)> wrote in message
news:20C67F12-3210-410D-8AD5-(E-Mail Removed)...
>I am trying to count number of entries in a column meeting 2 conditions -
>one
> condition being column1 values being >=100% & column2 values = "Text".
>
> I am getting total number of entries meeting Column2="Text" minus
> Column1>=100%
>
> --
> Alisaheb

my intended total is 3 from your example as only 3 entries are >=100%
--
Alisaheb


"jatman" wrote:

> If your data set is as follows:
>
> A B
> 100% empty
> 56% yes
> 107% no
> 103% text
> 75% text
>
> if your intended total is 5 then use the formuale as follows:
> =SUM(COUNTIF(A:A,">=100%"),COUNTIF(B:B,"TEXT"))
>
> jatman
>
>
> "alisaheb" wrote:
>
> > I am trying to count number of entries in a column meeting 2 conditions - one
> > condition being column1 values being >=100% & column2 values = "Text".
> >
> > I am getting total number of entries meeting Column2="Text" minus
> > Column1>=100%
> >
> > --
> > Alisaheb

Thanks for the solution, I got the correct answer.
--
Alisaheb


"Bob Phillips" wrote:

> =SUMPRODUCT(--(A2:A200>=100%),--(B2:B200="TEXT"))
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "alisaheb" <(E-Mail Removed)> wrote in message
> news:20C67F12-3210-410D-8AD5-(E-Mail Removed)...
> >I am trying to count number of entries in a column meeting 2 conditions -
> >one
> > condition being column1 values being >=100% & column2 values = "Text".
> >
> > I am getting total number of entries meeting Column2="Text" minus
> > Column1>=100%
> >
> > --
> > Alisaheb
>
>
>