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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count based on string in cell 2
If function in a sum?? 4
Multiples conditions in an array 3
Help With Sumif 2
if function, how? 4
Sumif condition 2
A function that verifies pair matches 4
Subtotal function 3

Back
Top