本帖最后由 shaowu459 于 2024-7-18 17:06 编辑
更新一下,减少一个bycol和vstack:
- =LET(f,LAMBDA(f,n,IF(OR(A$2:A$73=n),LET(s,FILTER(B$2:C$73,A$2:A$73=n),BYCOL(N(TAKE(s,,1)={"儿子","女儿"}),SUM)+REDUCE({0,0},DROP(s,,1),LAMBDA(x,y,x+f(f,y)))),{0,0})),f(f,E2))
复制代码 下面这个字符少几个,不过没什么意义
- =LET(d,A$2:A$73,f,LAMBDA(f,n,IF(OR(d=n),LET(s,FILTER(B$2:C$73,d=n),BYCOL(N(TAKE(s,,1)={"儿子","女儿"}),SUM)+REDUCE(0,s,LAMBDA(x,y,x+f(f,y)))),{0,0})),f(f,E2))
复制代码- =LET(d,A$2:A$73,f,LAMBDA(f,n,IF(OR(d=n),COUNTIFS(A:A,n,B:B,{"儿子","女儿"})+REDUCE(0,FILTER(C$2:C$73,d=n),LAMBDA(x,y,x+f(f,y))),{0,0})),f(f,E2))
复制代码- =LET(d,A$1:A$73,f,LAMBDA(f,n,IF(OR(d=n),COUNTIFS(A:A,n,B:B,{"儿子","女儿"})+REDUCE(,IF(d=n,C$1:C$73),LAMBDA(x,y,x+f(f,y))),{0,0})),f(f,E2))
复制代码
|