Count cells (not value) greater than 0

I want to count the number of cells in a range, not the value within those cells - but only the number of cells that have a value greater than 0. what is that formula?

I've attached a piece of the worksheet i am working on. I would like to insert that formula on cell AE4. Thank you for your help!

see COUNTIF in XL Help:

=COUNTIF(K4:AC4,">0")

I want to count the cells containing the lowest number but omitting any cells with zero...

E.I Column A

ROW 1 0
ROW 2 51
ROW 3 0
ROW 4 46
ROW 5 40
ROW 6 0

=IF(SUM(A1:A6)<>0,SUM(SMALL(A1:A6,{1,2,3,4,5,6})),0)
This formula works for most instances depending on the position of the "0". It won't work for the above example..can someone help

CdnFillie, unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.