Ouch. I´ve just realized That you may have more than 1 person for the same
project.

i´m not sure but i´m afraid you´ll need a macro. That´s away out of my league.
Sorry i can´t help

Best regards

"Vanessa Simmonds" escreveu:

Good Afternoon,

I want to use sumif however not to sum numerical data but to put text cell
together.

For example:

A B
Project Number Co-Supervisor
109969 Gabriel
110815 Bowden
110127 Barnett
110815 Vlachos

I need a formula that could look at column A, find the reference 110815 and
add up the text in column B.

Project Number Co-Supervisor
110815 Bowden / Vlachos

Best Regards,

Vanessa Simmonds