求助各位老师：隔列求和问题

584332210

走过路过的老师们，我想用函数求和，总是出问题，本人初学函数，还望各位大神赐教，帮帮忙。条件区域是O列买家列，条件是各个买家，求和区域是F、I、M、N列。用透视表，或者买家列在左边的话，用SUM+SUMIF+OFFSET函数组合得出结果，买家列在右边我就不会了请各位老师指教。。。版本是WPS2019专业版

无关岁月

1. =SUM(SUMIF(O$2:O$1203,C1207,OFFSET(E$2:E$1023,,{1,4,8,9})))

复制代码

quqiyuan

1. =SUMPRODUCT((F$2:F$1203+I$2:I$1203+M$2:M$1203+N$2:N$1203)*(O$2:O$1203=C1207))

复制代码

浮生若梦~~~

=SUM(IFERROR((O$2:O$1203=C1207)*F$2:N$1203*{1,0,0,1,0,0,0,1,1},))

ww87725244

=SUM(FILTER(F:N,O:O=C1207))

edwin11891

1. =GROUPBY(O2:O1203,BYROW(CHOOSECOLS(F2:N1203,{1,4,8,9}),SUM),SUM,,,,ISNUMBER(MATCH(O2:O1203,C1207:C1211,)))

复制代码

你是那块小饼干

=SUMPRODUCT((F$2:F$1203+I$2:I$1203+M$2:M$1203+N$2:N$1203)*(O$2:O$1203=C1207))

hugeinfo

=SUM(CHOOSECOLS($F$2:$N$1203,1,4,8,9)*($O$2:$O$1203=C1207))

jisijie630

=SUM(SUMIF(O:O,C1207,OFFSET(E:E,,{1,4,8,9})))

584332210

quqiyuan 发表于 2024-10-25 18:59

谢谢老师指导，已解决