Unique Id in one sheet and Duplicates Id in another sheet
Morena
✭✭✭✭
Hi Good people
I have two sheets - FTTH Program sheet and the PMO_DataDump sheet
On the FTTH Program sheet i have the unique id - PN number and on the PMO_DataDump also have the unique id with duplicates (PN Number), I'm trying to Calculate the sum from the column called HP from PMO_DataDump sheet for every unique Id in FTTH Program sheet.
Any Advice, please
Tags:
Answers
-
Used this formula -
=SUMIF(DISTINCT(COLLECT({PMO_DataDump_PN}; {PMO_DataDump_PN}; PN@row)); PN@row; {PMO_DataDump_HP})
But I get an error - #INCORRECT ARGUMENT
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!