Hacker News new | ask | show | jobs
by sedatk 3570 days ago
What does that mean?
1 comments

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.