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

Two columns followed by single page-width column on same page 0
Two columns : Continuous two columns vs Parallel two Column 1
Format column widths from one table to a separate table on same page 1
Need Help with a VBA subroutine 0
List all tables, including document structure 0
How to count non blank cells with a condition? 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Dividing existing content into two cells 2

Top