Hello everybody,
I am trying to make a formula that will count each result of array formula when that result is greater than ...
This is what i am trying =COUNTIF(E2:E8/C2:C8,">0.49")
I managed to achieve it by making additional column and counting that one then hiding it, but i would like to achieve it without additional column
Sample data.
<tbody>
</tbody><colgroup><col><col></colgroup>
I am trying to make a formula that will count each result of array formula when that result is greater than ...
This is what i am trying =COUNTIF(E2:E8/C2:C8,">0.49")
I managed to achieve it by making additional column and counting that one then hiding it, but i would like to achieve it without additional column
Sample data.
6 | 3 |
23 | 18 |
4 | 1 |
19 | 4 |
37 | 33 |
23 | 8 |
24 | 5 |
Thank you |
<tbody>
</tbody><colgroup><col><col></colgroup>