|
本帖最后由 pxiceplay 于 2019-12-23 12:11 编辑
凑个热闹:
数组公式
=SUM(C3:K11*(IF(O2<6,(ABS(ROW(C3:K11)-7)=5-$O$2)+(ABS(COLUMN(C3:K11)-7)=5-$O$2))+IF(O2>6,((ROW(C3:K11)-7)^2+(COLUMN(C3:K11)-7)^2=2))+IF(O2=8,(ABS(ROW(C3:K11)-7)+ABS(COLUMN(C3:K11)-7)=4))=0))-IF(O2>5,G7)
简化一下
=SUM(C3:K11*((ABS(ROW(1:9)-5)=5-O2)+(ABS(COLUMN(A:I)-5)=5-O2)+IF(O2=8,ABS(ROW(1:9)-5)+ABS(COLUMN(A:I)-5)=4)=0))-(O2>5)*G7-(O2>6)*(F6+F8+H6+H8)
======================
看漏了整体引用的需求,重来:
=SUM(C3:K11*(IF(O2<6,(ABS(ROW(3:11)-7)=5-O2)+(ABS(COLUMN(C:K)-7)=5-O2))+(ABS(COLUMN(C:K)-7)<(O2-5))*IF(O2>5,ABS(ROW(3:11)-7)=ABS(COLUMN(C:K)-7))+IF(O2=8,(ABS(ROW(3:11)-7)+ABS(COLUMN(C:K)-7)=4))=0))
简化:
=SUM(C3:K11*((ABS(ROW(1:9)-5)=5-O2)+(ABS(COLUMN(A:I)-5)=5-O2)+(ABS(ROW(1:9)-5)<(O2-5))*(ABS(ROW(1:9)-5)=ABS(COLUMN(A:I)-5))+IF(O2=8,ABS(ROW(1:9)-5)+ABS(COLUMN(A:I)-5)=4)=0))
|
评分
-
9
查看全部评分
-
|