Hi,
I have the following table and I would like to count the amount of rows in which either column x, y OR z has a value greater than 0. I'm assuming this has to be done with an array formule as I do not want to create a helper column.
In the example below, the result of this calculation is 5 (rows A, C, D, F and G have a value in one of the 3 columns greater than 0).
<tbody>
</tbody>
Does anyone know how to do this?
I have the following table and I would like to count the amount of rows in which either column x, y OR z has a value greater than 0. I'm assuming this has to be done with an array formule as I do not want to create a helper column.
In the example below, the result of this calculation is 5 (rows A, C, D, F and G have a value in one of the 3 columns greater than 0).
x | y | z | |
A | 0 | 1 | 0 |
B | 0 | 0 | 0 |
C | 1 | 1 | 1 |
D | 0 | 0 | 1 |
E | 0 | 0 | 0 |
F | 1 | 1 | 0 |
G | 0 | 1 | 1 |
<tbody>
</tbody>
Does anyone know how to do this?