Formula Help - SumProduct Formula to return value only once in the event of duplicate row

[Johnny Thunder]

Hello all,

I have a spreadsheet that contains a list of PO Numbers, the list may at times have the same PO repeated on different rows. I need a modification to my formula to be able to only show the result once if there is a duplicate row. Not sure of a way to do this so hopefully someone has done something like that.

Here is my current formula: =SUMPRODUCT((PONumber=C6)*AMZNSUM)

PONumber is a named range which contains all the PO Numbers, AMZNSUM is the range with my Dollar Amounts.

If any other details are needed to achieve this formula please let me know.

 

[DanteAmor]

Do you need something like this?

Book1
	A	B	C	D	E	F
1
2
3
4
5			PONumber	Value
6			123	71	216
7			123	72
8			123	73
9			124	74	149
10			124	75
11			125	76	76
12
Sheet

Cell Formulas
Range	Formula
E6:E11	E6	=IF(COUNTIF($C$6:C6,C6)=1,SUMPRODUCT((PONumber=C6)*AMZNSUM),"")

 

[Johnny Thunder]

That was exactly what I was looking for! Thanks again Dante!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.