If...rows and columns

  • Thread starter Thread starter something68
  • Start date Start date
S

something68

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...
 
This formula =SUMIF(A1:A10,"A",B1:B10) is read as: look at A1:A10 , locate
cells with "A", and add all corresponding B values. But the answer is 24
(=8+8+8). Where is your 16 coming from?
best wishes
 
Back
Top