Newbie with excell , need help on formula...

  • Thread starter Thread starter leave alone
  • Start date Start date
L

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?
 
Back
Top