Goal is to return detail results (not the final answer; i.e. a string”{0;0;0;25.88;…}” of an array function in cell P8 to cell U8 as text. At that point I can use the substitute function to get what I need.

The array function in P8 is {=sum(IF(RangenameA=$K8)*(RangeNameB="mytest"),TotaliWant,0))}. It returns the correct value. However, I have a need to scrub off the 0's and be left with what makes up the amount ie. 15.88+24.5+...

These ranges contain a large number of rows.

I have looked but not been able to find sample code on point. Thank you for your interest.