Use the below formula. It should be 24 ? isnt it..

=SUMIF(A1:A10,"A",B1:B10)
--
If this post helps click Yes
---------------
Jacob Skaria


"something68" wrote:

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...