Value separation and then adding

  • Thread starter Thread starter Walt Moeller
  • Start date Start date
W

Walt Moeller

Here is what I would like to do:

If any cell in this list k10,k36 = "R-C" the take the corresponding cell in
e10,e36 and add as a total in e37
 
Try this:

E37: =SUMIF(K10:k36,"R-C",E10:E36 )

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Back
Top