Sheets - Split cell into list(Array) and find average - Not across columns

sayth Source

If I have cell A1 with value 73562

How can I split it so that I create an array that I can then find the average of?

so for cell A1 I want the answer in B1 to be 4.6.

That is the average of


I thought array syntax on split would work, but it errors.



answered 1 month ago pnuts #1

Please try:


comments powered by Disqus