| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif concatenate formula
I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in
cell 3 that is based on what is in cells 1 and 2. Example: 1 - If there is a letter "A" in cell 1 or 2, then concatenate cells 1 and 2 in cell 3. 2 - If there is number in cell 1 and 2, then sum cells 1 and 2 in cell 3. Thanks for your help. Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with concatenate formula | Excel Worksheet Functions | |||
| Need help with concatenate formula | Excel Worksheet Functions | |||
| Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions | |||
| CONCATENATE formula | Excel Discussion (Misc queries) | |||
| concatenate like sumif | Excel Discussion (Misc queries) | |||
Threaded Mode
