求能下拉的公式

我的城市你来过

=INDEX(C:C,CHOOSEROWS(IF($A$2:$A$9<>0,ROW($A$2:$A$9),""),ROW(A1)))*$B2/SUM(OFFSET(B$1,INDEX(LOOKUP(ROW($A$2:$A$9),IF($A$2:$A$9<>0,ROW($A$2:$A$9)))-1,ROW(A1)),,LET(x,LOOKUP(ROW($A$2:$A$9),IF($A$2:$A$9<>0,ROW($A$2:$A$9))),SUM(IF(CHOOSEROWS(x,ROW(A1))=x,1,0)))))


=(B2/SUM(LET(x,LOOKUP(ROW($A$2:$A$9),IF($A$2:$A$9<>0,ROW($A$2:$A$9))),OFFSET($B$1,INDEX(x-1,ROW(A1)),,SUM(IF(CHOOSEROWS(x,ROW(A1))=x,1,0))))))*INDEX(C:C,CHOOSEROWS(LOOKUP(ROW($A$2:$A$9),IF($A$2:$A$9<>0,ROW($A$2:$A$9))),ROW(A1)))

=(B2/SUM(LET(x,LOOKUP(ROW($A$2:$A$9),IF($A$2:$A$9<>0,ROW($A$2:$A$9))),OFFSET($B$1,INDEX(x-1,ROW(A1)),,SUM(IF(CHOOSEROWS(x,ROW(A1))=x,1,0))))))*(1/LOOKUP(9,1/C$2:C2))

风雨相随3

求能下拉的公式.rar (14.3 KB, 下载次数: 1)

2024-2-22 21:01 上传

点击文件名下载附件

追加提问，公式如何填充？

无关岁月

选中C2：C13，输入公式，CTRL+enter

1. =SUM(B2:B$13)-SUM(C3:C$13)

复制代码