Sum of values across Arrays/Lists
I have a column that shows a set of values like this:
Row 1 20:40:0:0:20:0
Row 2 2:4:0:0:0:4
Row 3 . 0:0:0:0:0:0
Each row represents a project task.
The value represents the number of employees needed for the task across 6 different employee types/categories (categories separated by ":").
I need a formula the generates a SUM of the respective categories across all rows.
In this example the result would be:
Any advice is greatly appreciated
Help Article Resources
Check out the Formula Handbook template!