Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Conform a total to a list of results? | Excel Discussion (Misc queries) | |||
A COUNTIF function Challenge | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |