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
-
Try a SUMIFS.
=SUMIFS({Count Column}, {Location Column}, @cell = DND@row)
-
I figured out how to do it with COUNTIFS
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!