Formula that would allow me to calculate the sum of a column while skipping out the duplicate values in another column

[tonilrt]

Hi. I'm trying to find a formula that would allow me to calculate the sum of column b while skipping out the duplicate values in column a? In this example, the total would only be 519,750 since the last row repeats the DR-001144 from the first row.

DR-001144	173,250.00
DR-001148	173,250.00
DR-001146	173,250.00
DR-001144	173,250.00

 

[mehidy1437]

try,

Book1
	A	B
1	DR-001144	173,250.00
2	DR-001148	173,250.00
3	DR-001146	173,250.00
4	DR-001144	173,250.00
5	DR-001146	173,250.00
6	DR-001146	173,250.00
7	DR-001144	173,250.00
8	DR-001146	173,250.00
9	DR-001147	173,250.00
10		693000
Sheet2

Cell Formulas
Range	Formula
B10	B10	=SUMPRODUCT(1/COUNTIF(A1:A9,A1:A9&""),B1:B9)

 

[tonilrt]

try,

Book1
	A	B
1	DR-001144	173,250.00
2	DR-001148	173,250.00
3	DR-001146	173,250.00
4	DR-001144	173,250.00
5	DR-001146	173,250.00
6	DR-001146	173,250.00
7	DR-001144	173,250.00
8	DR-001146	173,250.00
9	DR-001147	173,250.00
10		693000
Sheet2

Cell Formulas
Range	Formula
B10	B10	=SUMPRODUCT(1/COUNTIF(A1:A9,A1:A9&""),B1:B9)

Thank you so much!

 

[mehidy1437]

You are welcome.