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
|