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

Morena

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