get count from multiple rows in one cell by unique identifer

I have a sheet "test" with a column named DND that has multiple rows with the same cell data. See my pictures, for example there are three lines for "location 1". I need to count the totals in the "Count" column for that location and put the result in my second sheet named "test2".

So, on "test2" sheet for "location 1" the answer should be 3.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!