Sum Cell Range (Min-Max) to Grand Range Total (Min-Max)

Kaleb

Smartsheet Community:

Does Anyone have a Solution for Totaling a Range in Each Cell to a Grand Total Range? See Example Below:

Range:

Row 1: $100k - $500k

Row 2 $100k - $500k

Row 3: $100k - $500k

Row 4: Total: $300,000 - $1,500,000

Thanks

ericncarr

The way I would do it is create a column for the bottom of the range and one for the top of the range. Then you could do =sum([Bottom Range]1:[Bottom Range:3]) and the same exact with the Top Range columns.

If you want it in that particular format you could have your third column (Range) concatenate the other two columns, though it's a little messy I guess:

="$" + [Bottom Range]@row + " - " + "$" + [Top Range]@row

ericncarr

The way I would do it is create a column for the bottom of the range and one for the top of the range. Then you could do =sum([Bottom Range]1:[Bottom Range:3]) and the same exact with the Top Range columns.

If you want it in that particular format you could have your third column (Range) concatenate the other two columns, though it's a little messy I guess:

="$" + [Bottom Range]@row + " - " + "$" + [Top Range]@row