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.

CONTRACTOR	INVOICE VALUE
AAA	1,000
BBB	2,000
AAA	1,500
CCC	500
AAA	3000

<tbody>
</tbody>

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!