| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| anova and means separation | Excel Worksheet Functions | |||
| date number separation | Excel Discussion (Misc queries) | |||
| Cell Separation | Excel Worksheet Functions | |||
| Decimals separation "." and "," | Excel Worksheet Functions | |||
| Decimals separation by . or , | Excel Discussion (Misc queries) | |||
Linear Mode
