哪位excel高手解释下面公式的含义啊,有个图片供大家参考,急,=SUM(OFFSET(OFFSET(INDIRECT(B$1&"月!$A$1"),MATCH("NB R&D allocation",INDIRECT(B$1&"月!A:A"),0)-1,1,1),2,2,MATCH("Total NB R&D expense",INDIRECT(B$1&"月!A:A"),0)-MATCH(
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/08 04:35:01
![哪位excel高手解释下面公式的含义啊,有个图片供大家参考,急,=SUM(OFFSET(OFFSET(INDIRECT(B$1&](/uploads/image/z/10430270-62-0.jpg?t=%E5%93%AA%E4%BD%8Dexcel%E9%AB%98%E6%89%8B%E8%A7%A3%E9%87%8A%E4%B8%8B%E9%9D%A2%E5%85%AC%E5%BC%8F%E7%9A%84%E5%90%AB%E4%B9%89%E5%95%8A%2C%E6%9C%89%E4%B8%AA%E5%9B%BE%E7%89%87%E4%BE%9B%E5%A4%A7%E5%AE%B6%E5%8F%82%E8%80%83%2C%E6%80%A5%2C%3DSUM%28OFFSET%28OFFSET%28INDIRECT%28B%241%26%22%E6%9C%88%21%24A%241%22%29%2CMATCH%28%22NB+R%26D+allocation%22%2CINDIRECT%28B%241%26%22%E6%9C%88%21A%3AA%22%29%2C0%29-1%2C1%2C1%29%2C2%2C2%2CMATCH%28%22Total+NB+R%26D+expense%22%2CINDIRECT%28B%241%26%22%E6%9C%88%21A%3AA%22%29%2C0%29-MATCH%28)
哪位excel高手解释下面公式的含义啊,有个图片供大家参考,急,=SUM(OFFSET(OFFSET(INDIRECT(B$1&"月!$A$1"),MATCH("NB R&D allocation",INDIRECT(B$1&"月!A:A"),0)-1,1,1),2,2,MATCH("Total NB R&D expense",INDIRECT(B$1&"月!A:A"),0)-MATCH(
哪位excel高手解释下面公式的含义啊,有个图片供大家参考,急,
=SUM(OFFSET(OFFSET(INDIRECT(B$1&"月!$A$1"),MATCH("NB R&D allocation",INDIRECT(B$1&"月!A:A"),0)-1,1,1),2,2,MATCH("Total NB R&D expense",INDIRECT(B$1&"月!A:A"),0)-MATCH("NB R&D allocation",INDIRECT(B$1&"月!A:A"),0)-1,16)*IF(OFFSET(OFFSET(INDIRECT(B$1&"月!$A$1"),MATCH("NB R&D allocation",INDIRECT(B$1&"月!A:A"),0)-1,1,1),1,2,1,16)=$A2,1,0)*IF(OFFSET(OFFSET(INDIRECT(B$1&"月!$A$1"),MATCH("NB R&D allocation",INDIRECT(B$1&"月!A:A"),0),1,1),1,MATCH("Total NB R&D expense",INDIRECT(B$1&"月!A:A"),0)-MATCH("NB R&D allocation",INDIRECT(B$1&"月!A:A"),0)-1,1)=$A$1,1,0))
哪位excel高手解释下面公式的含义啊,有个图片供大家参考,急,=SUM(OFFSET(OFFSET(INDIRECT(B$1&"月!$A$1"),MATCH("NB R&D allocation",INDIRECT(B$1&"月!A:A"),0)-1,1,1),2,2,MATCH("Total NB R&D expense",INDIRECT(B$1&"月!A:A"),0)-MATCH(
条件求和加动态引用,的确很复杂啊