How to combine the duplicate text values in one column and count/sum the values in other columns

Linda Xie
Linda Xie ✭✭
edited 04/25/23 in Formulas and Functions

Hello All,

I need some helps to achieve a goal between the source data sheet and a different output in destination sheet. Basically I am trying to combine duplicate texts in column "Facility Name" from source sheet shown below to a new sheet and group the value of sums or counts in totals for that combined text value. I don't necessarily need to keep the ID column in the New Sheet. I know there must be the formulas that can solve these type of inquires.

Many thanks in advance!

Source Data sheet

New Sheet Output


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!