Hello All, I am new to the forum and have a quick question:

I am using the filter and concatenate function to string a series of values together that are associated with the filter criteria. I have been able to get the formula to produce the values I want, however, as I am adding a comma between the values I am getting a result of a string of commas in the sum of the empty cells in the array I am pulling from. I need a solution that will allow me to ignore the commas if there are not values to display.

The equation I am using is: =ARRAYFORMULA(IFERROR(CONCATENATE(FILTER('4. SIA'!B4:B50,'4. SIA'!A4:A50=D216)&", "),""))

I am attempting to add picture but it seems I am doing something wrong


Thank you in advance for any assistance.


DeShaun