Notes on Excel

学习Excel函数.

  • How To Quickly Sum Every Other Or Nth Row/Column In Excel?: =SUMPRODUCT((MOD(COLUMN($A$1:$O$1),3)=0)\*($A$1:$O$1))
  • Advanced VLOOKUP in Excel: multiple, double, nested: 高级技巧还没用到
  • How to use VLOOKUP with SUM or SUMIF functions in Excel: LOOKUP后记得Ctrl+Shift+Enter, 且注意待查表一定要是排序好的
  • 🌟Sum every nth column: =SUM(FILTER(B5:J5,MOD(SEQUENCE(1,COLUMNS(B5:J5)),$K$2)=0)), FILTER函数可以过滤列, 从而避免了求和中遇到文字而报错#VALUE