Sum of values based on specific text

[NJS1982]

Hi all, hoping this is a nice easy one.
I have a list of contractors in column U (they appear more than once).
I have an invoice value for each transaction, set against these contractors in column X.
Does anyone know a formula to COUNT up the total value per contractor?

i.e. the value for AAA below would be 5,500. BBB would be 2,000. CCC would be 500.

[TABLE="width: 500"]
<tbody>[TR]
[TD]CONTRACTOR[/TD]
[TD]INVOICE VALUE[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]1,000[/TD]
[/TR]
[TR]
[TD]BBB[/TD]
[TD]2,000[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]1,500[/TD]
[/TR]
[TR]
[TD]CCC[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]AAA[/TD]
[TD]3000[/TD]
[/TR]
</tbody>[/TABLE]

Thanks!

 

[Joe4]

Use the SUMIF function. See: https://www.techonthenet.com/excel/formulas/sumif.php
Or possibly take a look at Pivot Tables or Subtotals, if you want a summary of everyone at once.

 

[wideboydixon]

=sumif(u:u,"aaa",x:x)

wbd

 

[NJS1982]

=sumif(u:u,"aaa",x:x)

wbd

GREAT! Many thanks, knew it was a simple one!