Dynamic Aggregation using LET Function Dynamic Array Formula #Excel 365=LET(range,D11:D17,select,F7,calc,CHOOSE(select,109,104,105,101),SUBTOTAL(calc,range))Useful in Dashboard Reporting | (MIS Reports / Sales)