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 I find it easier to split this into two formulas, one returning the month per category (+ "Total" row) and the other returning the value per category/month intersection (+Total of all returned values).
Month per Category
=LET(
FilteredList, FILTER(C1:C9,E1:E9 = B11),
CountRecords,ROWS(FilteredList),
IF(SEQUENCE(CountRecords+1)>CountRecords,"Total",FilteredList))
Value per Category/Month Intersection
=LET(
ValueColumn,D1:D9,
CategoryColumn,E1:E9,
MonthColumn,C1:C9,
UniqueList,A13#,
IF(UniqueList="Total",SUMIFS(ValueColumn,CategoryColumn,B11),SUMIFS(ValueColumn,MonthColumn,A13#,CategoryColumn,B11)))
Hope this helps,
Dexter