Newbie with excell , need help on formula...

[leave alone]

I am using a formula in excel =COUNT(A4:A43). Problem A4:A43 input data from
different part of sheet.

Not all cells may be used so the unused cells of A4:A43 defaults to 0.

My formula shows a count of 40 but I need t to only count values greater
then 0.

Any ideas on what formula to use?

 

[J.E. McGimpsey]

One way:

=COUNTIF(A4:A43,">0")

 

[leave alone]

thanks work like a charm

One way:

=COUNTIF(A4:A43,">0")