Forum Discussion
SeventhSpartan
Oct 13, 2021Copper Contributor
Sum of an Array's Rows: The Formula in this Cell Contains an Error and Eternal Apostrophe's
I'm attempting to create an array that automatically sums the rows of another array. For the sake of having an example here's an array to sum the rows of and I'll say it starts in A1 [=SEQUENCE(4,4,1...
- Oct 13, 2021
=MMULT(A1#,SEQUENCE(COLUMNS(A1#))^0)
Detlef_Lewin
Oct 13, 2021Silver Contributor
=MMULT(A1#,SEQUENCE(COLUMNS(A1#))^0)