I have a spreadsheet that I created and edit in Google Docs, and in one cell I have the following function
=SUM(FILTER(E9:E998,F9:F998>0))
It resolves the sum of all cells in column E, if there is a value greater than 0 in its corresponding cell in column F.
This works fine in Google Docs, but when I put it in Excel 2003, it tells me it is not a valid function.
Is there a way to achieve this such that it works in both places?
Bookmarks