Forum Discussion
Text after a Dynamic Array
I would like to put text at the end of a dynamic array formula result but can't seem to find any info. For example, I have a list of values and I would like to put a total at the bottom. Since the li...
Jwieczerzak If you are user of Microsoft 365 beta channel or current preview then can use VSTACK() and HSTACK(). As per my below screenshot (file is also attached) try-
=VSTACK(FILTER(C1:D9,E1:E9=H1),HSTACK("Total",SUM(FILTER(D1:D9,E1:E9=H1))))If you do not have access to VSTACK() function. Then could try-
=INDEX(FILTERXML("<t><s>"&TEXTJOIN("</s><s>",FALSE,FILTER(C1:D9,E1:E9=H1),"Total",SUM(FILTER(D1:D9,E1:E9=H1)))&"</s></t>","//s"),SEQUENCE(COUNTIF(E1:E9,H1)+1,2))