Dec 12 2019 12:21 PM
This is a Google doc formula for an array. I need to transfer the data to Excel. What is the right formula =ARRAYFORMULA(IFERROR(SUM(SPLIT(Y2:Y228,","))))
Dec 12 2019 01:06 PM
There is now SPLIT() function in Excel.
If your version supports TEXTJOIN() that could be like
=SUM(IFERROR(--MID(SUBSTITUTE(TEXTJOIN(",",TRUE,$Y$2:$Y$228),",",REPT(" ",LEN(TEXTJOIN(",",TRUE,$Y$2:$Y$228)))),(ROW($1:$1000)-1)*LEN(TEXTJOIN(",",TRUE,$Y$2:$Y$228))+1,LEN(TEXTJOIN(",",TRUE,$Y$2:$Y$228))),0)
Even better to put result of TEXTJOIN in helper cell and apply formula to it. Please see in cell A5 attached.
Dec 12 2019 01:23 PM
Thank you @Sergei Baklan
I'll give it a try!