| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding cells from two columns with contact into one cell
I want to know if it is possible to add content from two columns into one
cells with multiple criteria. example. column 1 criteria is either AM or PM and I have to beable to distinguish between the two. Column 2 is scheduled, unscheduled, tardy, etc., column 2 has like seven different criteria. Is there a way of doing this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding cells from two columns with contact into one cell
Not sure whether this is what you are looking for. Try the below in cell C2
with your text value in A2 and B2... =IF(AND(SUM(COUNTIF(A2,{"AM","PM"})), SUM(COUNTIF(B2,{"scheduled","unscheduled","tardy"} ))),A2&"-" &B2,"") -- Jacob (MVP - Excel) "gridenbaugh" wrote: I want to know if it is possible to add content from two columns into one cells with multiple criteria. example. column 1 criteria is either AM or PM and I have to beable to distinguish between the two. Column 2 is scheduled, unscheduled, tardy, etc., column 2 has like seven different criteria. Is there a way of doing this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for adding cells in different rows and different columns | Excel Worksheet Functions | |||
| Adding sums in rows and columns and colouring cells with condition | Excel Discussion (Misc queries) | |||
| Split one cell into 4 cells without adding columns? | Excel Discussion (Misc queries) | |||
| How do I turn 1 cell into 2 cells without adding columns or rows? | Excel Discussion (Misc queries) | |||
| Excel contact list-going from one row to mult. columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
