Excel 365 Vstack and "Total"

[Sourdough123]

Hi can you assist me in Adding "Total" at end of data
thisiis formula
=LET(u,UNIQUE(FILTER($CI$50:$CI$1000,$CI$50:$CI$1000<>"")),s,SUMIFS($CK:$CK,$CI:$CI,u,$CJ:$CJ,CP49),TAKE(SORT(FILTER(HSTACK(u,s),s<>0),2,-1),10))
Thanks

 

[Fluff]

Do you mean you want the word Total to appear below the last row?

 

[Sourdough123]

Do you mean you want the word Total to appear below the last row?

Yes Please

 

[Fluff]

Ok, how about

=LET(u,UNIQUE(FILTER($CI$50:$CI$1000,$CI$50:$CI$1000<>"")),s,SUMIFS($CK:$CK,$CI:$CI,u,$CJ:$CJ,CP49),VSTACK(TAKE(SORT(FILTER(HSTACK(u,s),s<>0),2,-1),10),{"Total",""}))

 

[Sourdough123]

=LET(u,UNIQUE(FILTER($CI$50:$CI$1000,$CI$50:$CI$1000<>"")),s,SUMIFS($CK:$CK,$CI:$CI,u,$CJ:$CJ,CP49),VSTACK(TAKE(SORT(FILTER(HSTACK(u,s),s<>0),2,-1),10),{"Total",""}))

Book1
	G	H
4	MSP	404,733.00
5	LATREAU	207,982.00
6	Spotlight	206,295.00
7	BTM JOINERY	95,460.00
8	Paxton Kitchens	87,728.00
9	Elk SSW	84,560.00
10	My Kitchen Co	77,006.00
11	Quantum Leap	65,520.00
12	76 Build	49,210.00
13	Total
14
Sheet1

get spill error for 10 items ( as per formula) but if i reduce it to 9 it works

can you sum total also please

 

[Fluff]

The Spill error suggests that either G14 or H14 (or both) are not empty.

 

[Sourdough123]

The Spill error suggests that either G14 or H14 (or both) are not empty.

Sorry remove contents
100%
Thanks

 

[Sourdough123]

Sorry remove contents
100%
Thanks

Can we just add up to get value for "Total" then
Please

 

[Fluff]

How about

=LET(u,UNIQUE(FILTER($CI$50:$CI$1000,$CI$50:$CI$1000<>"")),s,SUMIFS($CK:$CK,$CI:$CI,u,$CJ:$CJ,CP49),VSTACK(TAKE(SORT(FILTER(HSTACK(u,s),s<>0),2,-1),10),HSTACK("Total",SUM(s))))

 

[Sourdough123]

Book1
	G	H
4	Aretha	Job Value
5	MSP	404,733.00
6	LATREAU	207,982.00
7	Spotlight	206,295.00
8	BTM JOINERY	95,460.00
9	Paxton Kitchens	87,728.00
10	Elk SSW	84,560.00
11	My Kitchen Co	77,006.00
12	Quantum Leap	65,520.00
13	76 Build	49,210.00
14	Louws Carpentry	41,727.00
15	Total	1,483,974.00
16		163,753.00
17		1,320,221.00
Sheet1

=LET(u,UNIQUE(FILTER($CI$50:$CI$1000,$CI$50:$CI$1000<>"")),s,SUMIFS($CK:$CK,$CI:$CI,u,$CJ:$CJ,CP49),VSTACK(TAKE(SORT(FILTER(HSTACK(u,s),s<>0),2,-1),10),HSTACK("Total",SUM(s))))

This is not adding up
I cant see how
Thanks