Value separation and then adding
 

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
--
Walt Moeller

Value separation and then adding
 

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)

"Walt Moeller" wrote in message
...
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
--
Walt Moeller

Value separation and then adding
 

Try this:

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

HTH,
Paul

--

"Walt Moeller" wrote in message
...
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
--
Walt Moeller