CountIF and SumIFS for Total of $$ excluding Duplicates

[Nilous]

Hello,

Thank you for your help in advance.

I am trying to SUM a $ Amount that has rows with multiple $ amounts but same value. Please see example below.

I have tried countif to label the duplicates and then sumif based on what was tagged as a duplicate and what wasn't but can not get it to work.

Value	$ Amount	Needed Results
911​	$4,897.00​	$4,897.00​
921​	$2,945.00​	$2,945.00​
955​	$19,953.50​	$0.00​
955​	$1,273.00​	$21,226.50​
956​	$2,380.00​	$0.00​
956​	$1,767.00​	$0.00​
956​	$1,836.00​	$5,983.00​
974​	$9,923.00​	$9,923.00​

 

[steve the fish]

You could do:

=IF(COUNTIFS($A$2:A2,A2)=COUNTIFS(A:A,A2),SUMIFS(B:B,A:A,A2),0)

 

[DanteAmor]

If the values are ordered, it can be:

varios 29abr2020 lista de opciones eNum.xlsm
	A	B	C
1	Value	Amount	Needed Results
2	911	4,897.00	4,897.00
3	921	2,945.00	2,945.00
4	955	19,953.50	0.00
5	955	1,273.00	21,226.50
6	956	2,380.00	0.00
7	956	1,767.00	0.00
8	956	1,836.00	5,983.00
9	974	9,923.00	9,923.00
Hoja4

Cell Formulas
Range	Formula
C2:C9	C2	=IF(A3<>A2,SUMIFS(B:B,A:A,A2),0)

 

[Nilous]

both those responses are exactly what I'm looking for! Thank you so much! It appears I over complicated it.