=(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