3 ms·What does that mean?by sedatk 10y agoWhat does that mean?seanc 10y agoIn 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.