How to count all non zero entries in a column

[ihb95]

Hey guys,

I have following problem.
Right now I am counting the amount of rows in a column 2 by doing

Please Login or Register  to view this content.

I now want to count the rows in, let's say column 3, where the entry is not zero.
Or better: bigger than zero.
How can I achieve that simply?

Best regards!

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[nigelog]

One way

Please Login or Register  to view this content.

or simply

Please Login or Register  to view this content.

[ihb95]

Awesome! Thank you!

[nigelog]

Glad to help. If that answers your question can you please mark thread as solved.