Thread
:
countif challenge
View Single Post
#
2
Don Guillett
Posts: n/a
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
Reply With Quote