How to count visible rows and exclude zero?

[honkin]

I have some code which counts the number of selections in a column, but I would like it to exclude 0. it uses subtotal 103 so as to only count visible cells

Here is the code

=SUBTOTAL(103,AA16:AA1048561)

So how can I make this formula exclude all 0 in the column? I tried this, but it was not correct =SUBTOTAL(103,AA16:AA1048561,"<>0")

cheers

 

[honkin]

@JEC - FYI - the "-COUNTIF(A2:A10;0)" doesn't distinguish between filtered and unfiltered zeroes.
So if there are any zeroes in the hidden rows it will deduct more zeroes that it should.

That's nice to know Alex. In the end, I only tested it on unfiltered and it naturally matched the result with your solution. Thanks for the heads up. cheers