Hi, I have the following statement that works for what I need HOWEVER I now
need to also count the number of times "4.04" u2:u226 contains . I can't
figure out how to add this extra search criteria.

=SUM((COUNTIF(U2:U46,"3.028")+COUNTIF(U62:U226,"3. 028"))/COUNTA(U2:U46,U62:
U226))

I have column T2:t460 that contains product 3000, 4000,5000, 6000, 8000.
Then in column U2:u460 I have various versions. I need to figure the
percentage of 3000 & 5000 that equal 3.028 or 4.04 thanks for any help you
can offer.

--
Message posted via http://www.officekb.com

=(SUMPRODUCT(COUNTIF(U2:U46,{"3.028","4.04"}))+
SUMPRODUCT(COUNTIF(U62:U226,{"3.028","4.04"})))/COUNTA(U2:U46,U62:U226)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Debbie via OfficeKB.com" <u21726@uwe wrote in message
news:61ad47bef543b@uwe...
Hi, I have the following statement that works for what I need HOWEVER I
now
need to also count the number of times "4.04" u2:u226 contains . I
can't
figure out how to add this extra search criteria.


=SUM((COUNTIF(U2:U46,"3.028")+COUNTIF(U62:U226,"3. 028"))/COUNTA(U2:U46,U62:
U226))

I have column T2:t460 that contains product 3000, 4000,5000, 6000, 8000.
Then in column U2:u460 I have various versions. I need to figure the
percentage of 3000 & 5000 that equal 3.028 or 4.04 thanks for any help
you
can offer.

--
Message posted via http://www.officekb.com

Bob - Thank you soooo much. This works fabulously! I just have one more
question if you have time to answer. What do the { } brackets indicate as
opposed to ( )?

Bob Phillips wrote:
=(SUMPRODUCT(COUNTIF(U2:U46,{"3.028","4.04"}))+
SUMPRODUCT(COUNTIF(U62:U226,{"3.028","4.04"})))/COUNTA(U2:U46,U62:U226)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Hi, I have the following statement that works for what I need HOWEVER I now
need to also count the number of times "4.04" u2:u226 contains . I can't
figure out how to add this extra search criteria.

=SUM((COUNTIF(U2:U46,"3.028")+COUNTIF(U62:U226,"3 .028"))/COUNTA(U2:U46,U62:
U226))

I have column T2:t460 that contains product 3000, 4000,5000, 6000, 8000.
Then in column U2:u460 I have various versions. I need to figure the
percentage of 3000 & 5000 that equal 3.028 or 4.04 thanks for any help you
can offer.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1

Hi Debbie,

The curly brackets are used to contain an array of constant values, so the
COUNTIF works on the array, that is both 3.028 and 4.04, rather than a
single value

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Debbie via OfficeKB.com" <u21726@uwe wrote in message
news:61b5ba85cc4f6@uwe...
Bob - Thank you soooo much. This works fabulously! I just have one more
question if you have time to answer. What do the { } brackets indicate as
opposed to ( )?

Bob Phillips wrote:
=(SUMPRODUCT(COUNTIF(U2:U46,{"3.028","4.04"}))+
SUMPRODUCT(COUNTIF(U62:U226,{"3.028","4.04"})))/COUNTA(U2:U46,U62:U226)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Hi, I have the following statement that works for what I need HOWEVER I
now
need to also count the number of times "4.04" u2:u226 contains . I
can't
figure out how to add this extra search criteria.


=SUM((COUNTIF(U2:U46,"3.028")+COUNTIF(U62:U226,"3 .028"))/COUNTA(U2:U46,U62:
U226))

I have column T2:t460 that contains product 3000, 4000,5000, 6000,
8000.
Then in column U2:u460 I have various versions. I need to figure the
percentage of 3000 & 5000 that equal 3.028 or 4.04 thanks for any help
you
can offer.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1

Bob, Excellent, I can't thank you enough for this information!!!

Bob Phillips wrote:
Hi Debbie,

The curly brackets are used to contain an array of constant values, so the
COUNTIF works on the array, that is both 3.028 and 4.04, rather than a
single value

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Bob - Thank you soooo much. This works fabulously! I just have one more
question if you have time to answer. What do the { } brackets indicate as
[quoted text clipped - 22 lines]
percentage of 3000 & 5000 that equal 3.028 or 4.04 thanks for any help you
can offer.

--
Message posted via http://www.officekb.com