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).
This question generated 25 answers. To proceed to the answers, click here.
This thread is current as of March 11, 2014.