Excel function Google doc formula for an array

[laurel090]

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,","))))

[#2]

@laurel090 

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.

[#3]

Thank you @Sergei Baklan 

I'll give it a try!