Using countif, I know how to count how many cells are greater than a specific number, or another specific cell in a set of data. But I dont know how to do that or a range of data. I'll put an example to make myself clear:
<tbody>
</tbody>
Say that here, I want to count how many cells in column B, are greater than the respective cells in columns C and D (e.g B1 > C1 & B1 > D1; B2 > C2 & B2> D2, and so on). I want a formula that yields 3, which would be the answer. I'm playing with countifs, but can't seem to get what I want. I'm currently using countifs, because I also need my answer to only take into account those values where A = 1 (hence my final answer should actually be 2 in this example up here).
Any help would be appreciated.
A | B | C | D |
1 | 171 | 3 | 0 |
1 | 78 | 3 | 3 |
0 | 132 | 6 | 1 |
0 | 2 | 55 | 65 |
1 | 30 | 45 | 35 |
<tbody>
</tbody>
Say that here, I want to count how many cells in column B, are greater than the respective cells in columns C and D (e.g B1 > C1 & B1 > D1; B2 > C2 & B2> D2, and so on). I want a formula that yields 3, which would be the answer. I'm playing with countifs, but can't seem to get what I want. I'm currently using countifs, because I also need my answer to only take into account those values where A = 1 (hence my final answer should actually be 2 in this example up here).
Any help would be appreciated.