Using 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? (
know I can create a whole new column with if(a1=abc, then b1), but I'
rather do it in one step.).

Thanks so much! I'm sorry about the repost from Excel general, but
didn't know which was the right forum to post in.

R
 
See answer posted in excel.misc.

Please don't post the same message to multiple newsgroups. It just tends
to fragment your answers, and potentially wastes the time of those
replying to questions that have already been answered.
 
Back
Top