Concatenate several cells in an array formula

[pQp]

I need to have a cell display the text from several others using an array.
My columns are named: dates, item, style, amount_.
I sum the amount for different items per month with this formula:
{=SUM((IF(MONTH(dates)=6,1,0)*(item="Tshirt"))*amount_)}
so far so good.
Next to that total sum, I now want to display the tshirt styles sold that
month, all in one cell separated by a comma....
My guess is I need a similar array formula but with a concatenate 'style' .
...Or I might be completely off track! Can someone put me on track?
Thanks gang.

 

[Aladin Akyurek]

=SUBSTITUTE(MCONCAT(IF((MONTH(dates)=6)*(item="Tshirt),","&style,"")),",",""
,1)

which you need to confirm with control+shift+enter instead of just with
enter. The result string is limited to 255 chars.

MCONCAT is part of the morefunc.xll add-in you can download from:
http://longre.free.fr/english.

 

[pQp]

Thank you very much. I downloaded this add-in last year and had forgotten to
install it!