Adding Columns of multidimensional arrays


#1

I have and array with 6 columns separated by a tab() character, the rows are separated by cr(). How can I total all the values together in the shared column?


#2

This example will display the first column total for a multi-column array:

message arraynumerictotal(arraycolumn(myarray, 1, ¶, tab()),¶)

You obviously get the total for another column by changing the “1” in the formula to the next desired column number.