View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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