I'm trying to sum arrays, vertically, using just a single formula. Any ideas? Thanks in advance!
Example:
5,3,1
-----
4,5,6
-----
2,9,3
-----
--> 11,17,10
Another example:
How to sum arrays vertically in Google Sheets?
snidsnid
0
Viewed 28
1 Answers
try:
=INDEX(TEXTJOIN(",", 1, MMULT(1*TRANSPOSE(IFERROR(SPLIT(A1:A3, ","))),
SEQUENCE(COLUMNS(SPLIT(A1:A3, ",")), 1, 1, 0))))
Related