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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]171[/TD]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]78[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]132[/TD]
[TD]6[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]2[/TD]
[TD]55[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]30[/TD]
[TD]45[/TD]
[TD]35[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]171[/TD]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]78[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]132[/TD]
[TD]6[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]2[/TD]
[TD]55[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]30[/TD]
[TD]45[/TD]
[TD]35[/TD]
[/TR]
</tbody>[/TABLE]
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.