Hi, welcome to the forum

Perhaps like this...
A
B
C
1
 Anglo-Eastern Ship Management Ltd (HKG)
1
6
2
 Anglo-Eastern (Antwerp) NV
1
3
 Anglo-Eastern (Germany) GmbH
1
4
 Anglo-Eastern (UK) Limited
1
5
 Anglo-Eastern Maritime Services Pte Ltd
1
6
 Anglo-Eastern Shipmanagement (Singapore)Pte Ltd
1
7
 aa
1
8
 bb
1
9
 cc
1


C1=SUMIF($A$1:$A$9,"Anglo-Eastern*",$B$1:$B$9)