If function in a sum??

  • Thread starter Thread starter ModelerGirl
  • Start date Start date
M

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


---
Message posted

.
You should be able to use =SUMIF(A2:A6,"=ABC",B2:B6)
Click to expand...
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
 
Back
Top