countif challenge

[Guest]

Here is the problem:

range F3:30 contain percentages
range J3:J30 contain an x where certain criteria were met (win or loss say)

need to say the following

if F3:F30 is greater than or equal to xx% and there is an x in J3:J30 then
count it

have tried =sumproduct funcion as well with no luck.

All your help is appreciate
=countif(and(j3:j30="x"),f3:f30,">=80%") this gives error, I hear that you
cannot use these 2 functions together.

have tried

 

[Don Guillett]

try this idea
=SUMPRODUCT((F2:F200>=0.02)*(G2:G200="X"))