Adding cells from two columns with contact into one cell

G

gridenbaugh

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?
 
J

Jacob Skaria

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,"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting blank cells within two columns 2
sorting two columns of merged cells 1
Dividing existing content into two cells 2
Summing cells based on mulitiple criteria over mulitple columns 1
Excel Concatenate with line breaks but ignore blank cells 3
Comparing data between two columns 4
Split one cell into 4 cells without adding columns? 2
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells 1

Top