Adding all items in a list

[illmill 87]

Okay, so what's the best way to get the sum of all items in a list. Let's say I have a list of 20k numerical values. Every list item (except for the first one is a column header since this is coming from a csv) is a number and I want to calculate the total of all those numbers.

 

Thanks in advance for any tips you can offer!

[rotem 4]

I think this should work, didnt test it though.

 

set(#count, 0, "Global")

set list position(%yourList, 1)

loop($subtract($list total(%yourList), 1)) {

set(#count, $add(#count, $next list item(%yourList)), "Global")

}