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
|