On Mar 10, 7:25*am, UlvaZell
wrote:
Is there a text counterpart to the SUMIF function? *Something like a
concatenate if? *I have a table of data and based upon various numeric values
in the data array I would like to concatenate various associated
with each of the numeric values...

I put numeric values in A2:A30 and associated text strings in B2:B30.

Then I put this in C2:
=C1&IF(A233,B2&" ","")
and copied down to C30. I arbitrarily used "33" as the condition;
i.e., as the "if" part of "concatenate if". Replace that condition
with what's relevant in the case at hand.

If I understand correctly, the desired result is in C30.

If desired, the partial results in C2:C29 can be hidden (using
conditional formatting, for example).