Sum of values across Arrays/Lists

alexmans
alexmans
edited 12/09/19 in Formulas and Functions

Hi there,

I have a column that shows a set of values like this:



             COLUMN A

Row 1   20:40:0:0:20:0

Row 2   2:4:0:0:0:4

Row 3 .  0:0:0:0:0:0

etc.



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:



Result   22:44:0:0:20:4



Any advice is greatly appreciated

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!