Calculate data without duplicate values and additional decimal issues

[Aggro]

Hi 

I want to sum the amount column without the duplicated amount and decimal issues.

Current Data:
Tracking number	Invoice number	Amount		Note (not in the table)
ABCD-1234	XYZ	7		<< Duplicated
ABCD-1234	LMN	7
ABCD-1234	PQWE	1
ABCD-1235	SDA	5		<< Duplicated
ABCD-1235	EWRW	5		<< Duplicated
ABCD-1235	OPWE	5
ABCD-1235	TWERT	750		decimal issues, which is the 100th  of the other record
ABCD-1235	TWERT	7.5
ABCD-1236	QOWOE	6
Expected Result:
Tracking number		Expense		Note (not in the table)
ABCD-1234		8		expense is 7 +1 without that duplicate
ABCD-1235		12.5		expense is 5+7.5  without that duplicate and 100th of the record
ABCD-1236		6

[danextian]

Hi @Aggro ,

Sans the notes, how do you know which ones are the duplicates?

[Aggro]

I don't, but at this time, we want only to sum up one record instead of all (among the duplicate ones).