Adding cells from two columns with contact into one cell

  • Thread starter Thread starter gridenbaugh
  • Start date Start date
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?
 
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,"")
 
Back
Top