[seanc]

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.

[greggyb]

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