Hey!
I am stuck on a simple yet seemingly difficult task for excel. All I want to do is count the number of cells for specific columns, yet I haven't found a formula which could work.
<tbody>
</tbody>
I need to count the columns for "j" and "n" separately (and add them together), but only for the numbers <2. So for "j" I should receive a result of 5+5+6=16 and for "n" 5+6=11.
Does anybody have an insight into this problem?
Thanks
I am stuck on a simple yet seemingly difficult task for excel. All I want to do is count the number of cells for specific columns, yet I haven't found a formula which could work.
j | n | n | j | j |
0 | 0 | 1 | 1 | 0 |
1 | 0 | 1 | 99 | 0 |
0 | 1 | 1 | 1 | 1 |
1 | 0 | 0 | 1 | 1 |
99 | 0 | 0 | 1 | 1 |
0 | 99 | 1 | 1 | 0 |
<tbody>
</tbody>
I need to count the columns for "j" and "n" separately (and add them together), but only for the numbers <2. So for "j" I should receive a result of 5+5+6=16 and for "n" 5+6=11.
Does anybody have an insight into this problem?
Thanks