Sourdough123
Board Regular
- Joined
- Oct 25, 2021
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
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
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