excel 怎么只求最近三次的数据合

xunge888

工作簿1.zip (10.29 KB, 下载次数: 36)

2024-3-14 17:41 上传

点击文件名下载附件
1

各位大佬，如图，投放任务很多但又不是每一天都投放，我想取单任务最近三次的数据合 应该用什么公式。求大佬帮助！

624134745

=SUMIFS(C:C,B:B,F6,A:A,">="&LARGE(IF($B$2:$B$18=F6,$A$2:$A$18),MIN(3,COUNTIF(B:B,F6))))

miaojohn45

1. =SUM(TAKE(SORT(FILTER(A$2:C$18,B$2:B$18=F6),1,-1),3,-1))

复制代码

jisijie630

=SUM(OFFSET(C$1,MATCH(F6,B:B)-1,,-MIN(3,COUNTIF(B:B,F6))))

我的城市你来过

=SUM(CHOOSECOLS(TAKE(SORT(WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,IF($B$2:$B$18=$F6,HSTACK($A$2:$A$18,$C$2:$C$18),"")),,"-"),2),,-1),MIN(COUNTIFS($B$2:$B$18,$F6),3)),2)/1)

hxj119

=SUM(TAKE(SORT(FILTER($A$2:$C$18,$B$2:$B$18=F6),1,-1),3,-1))

mykitami

=SUM(TAKE(SORT(FILTER(A:C,B:B=F6)),-3,-1))

菜狗一只

1. =SUM(TAKE(SORT(FILTER($A$2:$C$18,$B$2:$B$18=F6),1,1),-3,-1))

复制代码

xunge888

624134745 发表于 2024-3-14 18:13
=SUMIFS(C:C,B:B,F6,A:A,">="&LARGE(IF($B$2:$B$18=F6,$A$2:$A$18),MIN(3,COUNTIF(B:B,F6))))

非常感谢大佬，我试试看

xunge888

我的城市你来过 发表于 2024-3-14 19:51
=SUM(CHOOSECOLS(TAKE(SORT(WRAPROWS(TEXTSPLIT(TEXTJOIN("-",,IF($B$2:$B$18=$F6,HSTACK($A$2:$A$18,$C$2: ...

我这边获取是失败了 不知道是不是版本问题