How do I summarize multiple cells from one sheet, into a single cell on another sheet?
I am trying to combine several cells of contact cards into one cell in a different sheet.
My source sheet has multiple columns listing project managers from multiple global sites working together on one project. Since they are at different sites/locations, these need to stay separated on the source sheet. In a separate sheet I am creating, I would like all of those cells to be summarized in just one cell to represent the entire project team.
^^So all of these cells that say "DPM or PM" I want to be combined into just one cell on my new sheet.
Hope this makes sense & there is a way to do this??
Help Article Resources
Check out the Formula Handbook template!