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

✭✭✭✭✭

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

• ✭✭✭✭✭
edited 05/13/22 Answer ✓

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

• ✭✭✭✭✭
edited 05/13/22 Answer ✓

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!