J
jbaden
71.43% 28.57% CountIF counted how many times a number
below 39 for column A and 36 column B.
A B
1 50.00 50.00
2 50.00 50.00
3 50.00 50.00
4 50.00 38.01
5 50.00 50.00
6 50.00 46.85
7 50.00 36.41
8 37.65 50.00
9 33.48 39.74
10 30.74 37.51
11 50.00 50.00
12 27.32 34.39
13 50.00 32.13
14 32.46 36.26
39.00 36.00
I am counting how many times a number comes up under 39 in column A and
how many times a number comes up in column B under 36. I want to
discrimante if for example row 12 is both under 39 and 36 si it is only
counted once.
below 39 for column A and 36 column B.
A B
1 50.00 50.00
2 50.00 50.00
3 50.00 50.00
4 50.00 38.01
5 50.00 50.00
6 50.00 46.85
7 50.00 36.41
8 37.65 50.00
9 33.48 39.74
10 30.74 37.51
11 50.00 50.00
12 27.32 34.39
13 50.00 32.13
14 32.46 36.26
39.00 36.00
I am counting how many times a number comes up under 39 in column A and
how many times a number comes up in column B under 36. I want to
discrimante if for example row 12 is both under 39 and 36 si it is only
counted once.