excel 公式 SUMPRODUCT((AO6:AO100=B6)*AP6:AP100)中如可把AO100 改成是AO6+94就是向下COPY时是: SUMPRODUCT((AO7:AO7+96=B7)*AP7:AP7+96)=SUMPRODUCT((AO7:AO101=B7)*AP7:AP101) SUMPRODUCT((AO8:AO8+96=B7)*AP8:AP8+96)=SUMPRODUCT((AO8:AO102=B
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/30 04:23:54
![excel 公式 SUMPRODUCT((AO6:AO100=B6)*AP6:AP100)中如可把AO100 改成是AO6+94就是向下COPY时是: SUMPRODUCT((AO7:AO7+96=B7)*AP7:AP7+96)=SUMPRODUCT((AO7:AO101=B7)*AP7:AP101) SUMPRODUCT((AO8:AO8+96=B7)*AP8:AP8+96)=SUMPRODUCT((AO8:AO102=B](/uploads/image/z/12450547-19-7.jpg?t=excel+%E5%85%AC%E5%BC%8F+SUMPRODUCT%28%28AO6%3AAO100%3DB6%29%2AAP6%3AAP100%29%E4%B8%AD%E5%A6%82%E5%8F%AF%E6%8A%8AAO100+%E6%94%B9%E6%88%90%E6%98%AFAO6%2B94%E5%B0%B1%E6%98%AF%E5%90%91%E4%B8%8BCOPY%E6%97%B6%E6%98%AF%EF%BC%9A+SUMPRODUCT%28%28AO7%3AAO7%2B96%3DB7%29%2AAP7%3AAP7%2B96%29%EF%BC%9DSUMPRODUCT%28%28AO7%3AAO101%3DB7%29%2AAP7%3AAP101%29+SUMPRODUCT%28%28AO8%3AAO8%2B96%3DB7%29%2AAP8%3AAP8%2B96%29%EF%BC%9DSUMPRODUCT%28%28AO8%3AAO102%3DB)
excel 公式 SUMPRODUCT((AO6:AO100=B6)*AP6:AP100)中如可把AO100 改成是AO6+94就是向下COPY时是: SUMPRODUCT((AO7:AO7+96=B7)*AP7:AP7+96)=SUMPRODUCT((AO7:AO101=B7)*AP7:AP101) SUMPRODUCT((AO8:AO8+96=B7)*AP8:AP8+96)=SUMPRODUCT((AO8:AO102=B
excel 公式 SUMPRODUCT((AO6:AO100=B6)*AP6:AP100)中如可把AO100 改成是AO6+94
就是向下COPY时是:
SUMPRODUCT((AO7:AO7+96=B7)*AP7:AP7+96)
=SUMPRODUCT((AO7:AO101=B7)*AP7:AP101)
SUMPRODUCT((AO8:AO8+96=B7)*AP8:AP8+96)
=SUMPRODUCT((AO8:AO102=B7)*AP8:AP102)
我想是要固定AO8+96,因为=SUMPRODUCT((AO8:AO102=B7)*AP8:AP102)的话
当删除统计行时公式会自动减少.
谢谢.
excel 公式 SUMPRODUCT((AO6:AO100=B6)*AP6:AP100)中如可把AO100 改成是AO6+94就是向下COPY时是: SUMPRODUCT((AO7:AO7+96=B7)*AP7:AP7+96)=SUMPRODUCT((AO7:AO101=B7)*AP7:AP101) SUMPRODUCT((AO8:AO8+96=B7)*AP8:AP8+96)=SUMPRODUCT((AO8:AO102=B
=SUMPRODUCT((OFFSET(AO6,100)=B6)*OFFSET(AP6,100))