Thread: SUMIF for Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vanessa Simmonds Vanessa Simmonds is offline
external usenet poster
 
Posts: 17
Default SUMIF for Text

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