Get correct total, ignoring duplicates

[prasha99]

There are multiple instances of same payment amount on same day with same PO number. I would like to get correct total ignoring duplicates. Thanks

 

[ETAF]

how are you planning on getting the total, is this a lookup - if so , then they usually only return the 1st instance
=INDEX(B:B,MATCH(A3&B3&C3,A:A&B:B&C:C,0))
OR
maybe use a AverageIFS() depending on excel version
=AVERAGEIFS(B:B,A:A,A3,B:B,B3,C:C,C3)

But i'm not sure how you are planning on using the total and where you want it

OR
if you want the spreadsheet cleaned up

 

[vletm]

prasha99
Could You give few samples of Your named correct totals?
Could You five few samples of Your named duplicated? ( which or all columns of data )