Do you mean that you want to join all the text values together to make
one long string? Do you want spaces or some other delimiter between
each text item? How many rows are you using on sh2?

Pete

On May 6, 5:38*am, bgkgmg wrote:
If I have text instead of numbers - what formula would I use that works like
SUMIF.
Example: On sh2 I want to copy text in B? where A? has the value of "Cotton"
to sh1 C32.