Hacker News Reader

The big win in Google spreadsheets is that functions are nearly universally composable. Unlike Excel.

What does that mean?

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.