网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索
excel吧 关注：281,170贴子：1,547,877
  • 10回复贴，共1页

函数题目！



=VSTACK({"城市","总金额"},HSTACK(A2:A5,BYROW(SUMIFS(C:C,A:A,A2:A5,B:B,B1:E1)*B2:E5,SUM)))


2025-06-08 19:18:46
广告

用index的一种方法
=GROUPBY(A9:A27,INDEX(B2:E5,MATCH(A9:A27,A2:A5,),MATCH(B9:B27,B1:E1,))*C9:C27,SUM,,0)


传统派
=MMULT(N(TRANSPOSE(A8:A26)=A2:A5),INDEX(B2:E5,MATCH(A8:A26,A2:A5,),MATCH(B8:B26,B1:E1,))*C8:C26)


Thank you so much for sharing.


=LET(a,VLOOKUP(A8:A26&B8:B26,TEXTSPLIT(TEXTJOIN(",",,A2:A5&B1:E1&"-"&B2:E5),"-",","),2,0)*C8:C26,REDUCE({"城市","总金额"},A2:A5,LAMBDA(x,y,VSTACK(x,HSTACK(y,SUM(FILTER(a,A8:A26=y)))))))
基础不到家就大力出奇迹


扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频！
  • 10回复贴，共1页
分享到: