In google spreadsheets I can do something like:

=count(filter(a1:z30>0))

where in Excel I'd have to make an extra column to store the result of the filter, and then count those.

You can use array formulas to achieve the same result in Excel.