Countname function

[rahullambe]

Hii,

I am facing a problem with count name function, I am attaching the sample copy of my data n I want to use count name function on another working sheet excluding "0" values cells in the list.

[Bob Phillips]

What CountName function might that be?

[rahullambe]

I mean "Counta" function but it should exclude the cells of value contain"0".

I also attached data copy wid my 1st post.

Thanks

[Bob Phillips]

=SUMPRODUCT(--(ISNUMBER(rng)),--(rng<>0))