Excel: Countif with matrix

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).

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
Does anyone know how to do this?

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of March 11, 2014.

For more resources for Microsoft Excel