Hello Alan,
sorry I forgot to tell you that the summation should only work for Part_Number with suffix 'W'. In my 2nd example the Part_Number has suffix 'B' and in deed in my database the Part_Numbers have many other suffixes, eg. R, T, CR, BX, 176500FA, etc.
I tried to amend this line as...