Add Dynamic Sum with Dynamic Array when using SUMIFS

[LearnMeExcel]

Hi all
i solve the first Problem for Dynamic name With Filter by @Fluff
on the Same Data
i want to Add Dynamic Sum with Same Dynamic Formula
this is my data

Invoice Number​	Date​	Company Name​	Amount​	Currency​	Status​
V - 141​	15/01/2021​	XYZ​	1153.132​	USD​	Not Paid​
V - 157​	17/01/2021​	FHG​	4491.818​	USD​	Paid​
V - 158​	26/01/2021​	ZJC​	6076.498​	USD​	Paid​
V - 167​	16/02/2021​	FHG​	1105.557​	USD​	Paid​
V - 173​	17/02/2021​	XYZ​	7338.599​	USD​	Paid​
V - 184​	21/02/2021​	CDE​	2176.351​	USD​	Paid​
V - 194​	06/03/2021​	THC​	7663.309​	USD​	Paid​
V - 204​	07/03/2021​	ZJC​	2955.909​	USD​	Paid​
V - 252​	23/03/2021​	MFC​	4456.528​	USD​	Paid​
V - 278​	28/03/2021​	ABC​	3432.406​	USD​	Paid​
V - 306​	28/03/2021​	MFC​	3381.936​	USD​	Not Paid​
V - 325​	31/03/2021​	JBR​	7563.771​	USD​	Paid​
V - 326​	31/03/2021​	FHG​	4094.144​	USD​	Paid​
V - 327​	19/04/2021​	EFG​	7828.469​	USD​	Paid​
V - 330​	21/04/2021​	MFC​	6602.376​	USD​	Not Paid​
V - 342​	23/04/2021​	XYZ​	2979.044​	USD​	Paid​
V - 374​	25/04/2021​	FHG​	7932.121​	USD​	Paid​
V - 387​	05/05/2021​	FHG​	3621.784​	USD​	Paid​
V - 397​	06/05/2021​	FHG​	4714.177​	USD​	Paid​
V - 415​	27/05/2021​	JBR​	4942.058​	USD​	Paid​
V - 433​	27/05/2021​	CDE​	7999.256​	USD​	Paid​
V - 434​	31/05/2021​	ABC​	2743.007​	USD​	Paid​
V - 478​	31/05/2021​	THC​	1122.415​	USD​	Paid​
V - 523​	02/06/2021​	EFG​	4673.887​	USD​	Paid​
V - 524​	16/06/2021​	JBR​	2126.972​	USD​	Paid​
V - 531​	21/06/2021​	XYZ​	8576.646​	USD​	Not Paid​
V - 544​	25/06/2021​	MFC​	8452.265​	USD​	Not Paid​
V - 616​	27/06/2021​	FHG​	6481.728​	USD​	Paid​
V - 637​	07/07/2021​	CDE​	4694.205​	USD​	Not Paid​
V - 671​	08/07/2021​	MFC​	3248.498​	USD​	Not Paid​
V - 677​	24/07/2021​	ZJC​	2986.056​	USD​	Paid​
V - 703​	07/08/2021​	THC​	1342.146​	USD​	Paid​
V - 759​	11/09/2021​	JBR​	4226.128​	USD​	Paid​
V - 770​	12/09/2021​	ZJC​	1949.528​	USD​	Paid​
V - 815​	14/09/2021​	MFC​	5725.759​	USD​	Not Paid​
V - 846​	28/09/2021​	FHG​	8204.793​	USD​	Paid​
V - 861​	29/09/2021​	MFC​	6108.563​	USD​	Paid​
V - 887​	01/10/2021​	FHG​	2274.161​	USD​	Paid​
V - 903​	10/10/2021​	ZJC​	5287.774​	USD​	Paid​
V - 910​	12/10/2021​	ZJC​	7230.193​	USD​	Not Paid​
V - 913​	12/10/2021​	ABC​	1109.748​	USD​	Paid​
V - 926​	29/10/2021​	CDE​	2849.42​	USD​	Paid​
V - 929​	01/11/2021​	FHG​	4117.116​	USD​	Paid​
V - 934​	04/11/2021​	MFC​	4752.744​	USD​	Paid​
V - 937​	07/11/2021​	XYZ​	4851.978​	USD​	Paid​
V - 938​	14/11/2021​	CDE​	7279.049​	USD​	Not Paid​
V - 965​	27/11/2021​	XYZ​	2766.666​	USD​	Paid​
V - 966​	28/11/2021​	JBR​	4601.909​	USD​	Paid​
V - 985​	06/12/2021​	CDE​	1092.158​	USD​	Paid​
V - 986​	15/12/2021​	EFG​	1015.34​	USD​	Not Paid​

my Unique list

Not Paid​

CDE​

EFG​

MFC​

XYZ​

ZJC​

By Formula
=SORT(UNIQUE(FILTER(INDEX(Invoice_data,,3),INDEX(Invoice_data,,6)="Not Paid")))
And i used SUMIFS

Not Paid​	Amount​
CDE​	11973.25​	=IF(I2#="",SUM($J$1:J1),SUMIFS(INDEX(Invoice_data,0,4),INDEX(Invoice_data,0,3),I2#,INDEX(Invoice_data,0,6),"Not Paid"))​
EFG​	1015.34​
MFC​	27410.83​
XYZ​	9729.778​
ZJC​	7230.193​

but Sum doesn't work to give me after last value the total for all

Can we do that ???

 

[Fluff]

As this is a completely different question, it needs a new thread. Thanks

 

[LearnMeExcel]

OK