arrayformula like in google sheets
I miss arrayformulas like provided by google sheets (s. https://support.google.com/docs/answer/3093275?hl=en)
5
votes
Proton Sheets returns array results by default without the need for a specific array formula function.
-
Bryan
commented
How does it work? When I use SUMIF with a range-based conditional, I don't get a result in the form of multiple rows, as I would when using ARRAYFORMULA(SUMIF) in Google Sheets. I seem to just get a sum of the elements of the array in a single cell
-
Bastien
commented
Is there currently an equivalent to gogole sheet arrayformula function?
I have a complex spreadsheet that cannot work without a similar function...