I usually do what @Soni Kumari recommended, but brainstormed and tested a slightly hokey alternative that I felt like sharing.
You can take advantage of the fact that COUNT(ColumnName) doesn't count NULLs, and use something like this:
SELECT COUNT(NULLIF(0, myColumn))
NULLIF - returns NULL if the two passed in values are equivalent.
Advantage: Shows your intent to COUNT rows instead of having the SUM() notation.
Disadvantage: Not as explicit how it is working ("magic" is usually bad).