Excel Functions: Countif Problems

  • Thread starter Thread starter jbaden
  • Start date Start date
J

jbaden

75.00% 33.33% 41.67%
A B C
37.65 50.00 37.64
33.48 39.74 46.95
30.74 37.51 34.89
27.32 34.39 34.35
50.00 32.13 31.65
32.46 36.26 34.45
31.77 34.31 35.10
27.74 34.06 37.71
35.17 50.00 50.00
29.04 36.93 37.01

38.50 36.00 36.40 Cuttoff


I am counting how many times a number comes up under 38.5 in column A
36 in column B and 36.40 in column C. Thus the percentages at the top
of the page. I want to combine both column A, B and C to create one
column and only one positive will be counted for each row. I want to
discrimante if for example, you take row 10. Both numbers in row 10
would be counted because they are under 38.5 and 36 for there respected
columns. I need to know how to discriminate against this so it is only
counted once in the percentage at the top when I combine the positives
in the columns????? Only one positive for each row is counted!!
 
Jbaden,

Assume your data is in A1:C10 with the cutoffs in A12:C12

=SUM(IF((A1:A10<=A12)+(B1:B10<=B12)+(C1:C10<=C12)>0,1,0))
array entered (control + shift + enter) if done properly braces { } will
appear around the formula...

{=SUM(IF((A1:A10<=A12)+(B1:B10<=B12)+(C1:C10<=C12)>0,1,0))}

Dan E
 
Back
Top