I am attempting to set up a spreadsheet whereby I can summarise the weight
load of a vehicle. The cells will contain a variation of abbreviated texts
in the same cell e.g.

An example of column B contents is ah, zy, pd, (in a single cell on each row)

Each abbreviation will have it's own unique number (weight) allocated in two
seperate column which the formula will refer to - i.e

Column IU IV
Row 1 ah 2.2
Row 2 zy 3.7
Row 3 pd 1.4

There will be approximately 50 such text references and values.

Currently column b (rows 1 to 50) contain the varied text (ah, zy, pd etc in
a single cell). Is it possible to 'find' the idividual text abbreviation
(ah, zy or pd) in column B and total the allocated weight using sumif or
sumproduct even though they are in the same cell?

Any suggestions greatly appreciated.