countif challenge
 

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

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

--
Don Guillett
SalesAid Software

"Alan D" <Alan wrote in message
...
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