If function in a sum??

[ModelerGirl]

I'd like to sum only those cells in a column for which a neighborin
cell equals a certain value. Here are the two columns:

ABC 15
DEF 12
ABC 1
ABC 17
DEF 222

I'd like to sum only those numbers that have an ABC in the cell on th
left. Is there anyway to do this in one step using the sum function
(I know I can create a whole new column with if(a1=abc, then b1), bu
I'd rather do it in one step.).

Thanks so much!

R

 

[Frank Kabel]

Hi
try
=SUMIF(A1:A100,"ABC",B1:B100)

 

[JE McGimpsey]

one way:

=SUMIF(A1:A5,"ABC",B1:B5)

 

[ModelerGirl]

Thanks to Frank and JE for such a quick response

 

[Mike]

-----Original Message-----
I'd like to sum only those cells in a column for which a neighboring
cell equals a certain value. Here are the two columns:

ABC 15
DEF 12
ABC 1
ABC 17
DEF 222

I'd like to sum only those numbers that have an ABC in the cell on the
left. Is there anyway to do this in one step using the sum function?
(I know I can create a whole new column with if(a1=abc, then b1), but
I'd rather do it in one step.).

Thanks so much!

R.


---


.
You should be able to use =SUMIF(A2:A6,"=ABC",B2:B6)

where A2 through A6 are your alpha characters and b2
through B6 are your numeric values. This can also be used
as just A:A and B:B without row numbers to include any
entries in the two columns. There is a good tutorial on
this and other uses for similar functions at:

http://www.microsoft.com/office/using/column10.asp#top

Hope this helps--Mike