Value separation and then adding

[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

 

[Ron Coderre]

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)

 

[PCLIVE]

Try this:

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

HTH,
Paul