SUMIF for Text

[Vanessa Simmonds]

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

 

[Vincent]

Hi Vanessa,

It´s my first time helping somebody (with excel).

You need to use the vlookup function. It goes something like this:

E2=vlookup(D2;$A$2:$B$2;2;FALSE)

Assuming you have:

Col D Col E
Project Number Co-Supervisor
110815 (insert formula here)

This formula looks up for 110815 (D2) in table $A$2:$B$2 and gives away the
value in the second column.

After you insert that formula and if you don´t have any value on the left
you´ll get a #N/D. So try using this one:

E2=If(D2="";"";vlookup(D2;$A$2:$B$2;2;FALSE))

Hope I did fine


"Vanessa Simmonds" escreveu:

 

[Vincent]

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: