I would like to know what type of formula I would use for the following:

A1, A5, A10 contain "A"; A3, A4, A7 contain "P"; A6 contains "S"
B1, B5, B10 contain "8.0"; B3, B4, B7 contain "8.0"; B6 contains "4.0"

How can I show in A11, all "A" = 16 (because of B1, B5, B10)?

Or is this too confusing? I have an excel sheet ready as an example...