3 ms·
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, an
by seanc 10y ago
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 10y agoYou can use array formulas to achieve the same result in Excel.