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