Hi All,

I'm after some help with the sumproduct formula.

I need to count the number of cells <>0.

My problem is that the cells are not in sequence i.e A1,C1,E1,G1.

Any idea's ?