If...rows and columns
 

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

If...rows and columns
 

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

If...rows and columns
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"something68" wrote in message
...
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...

If...rows and columns
 

The formula works! Thank you so much, I love it!

"Jacob Skaria" wrote:

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