当前时间： 2026-07-24 10:16:30
分类：办公文件
评论(0)
EXCEL篇-跨列求和今天聊一个看似简单、却让很多人头疼的问题——跨列求和比如下面这张产品销售记录表：计划列和实际列交错排列，1月计划、1月实际、2月计划、2月实际……每个月都是这样。现在要分别汇总“计划合计”和“实际合计”，你还在还在手动输入=B2+D2+F2逐个相加吗？- 条件区域
$B$1:$G$1：锁定表头行，用来识别每一列属于「计划」还是「实际」； - 条件 "*计划*"：*是 Excel 通配符，代表任意字符，只要表头文字包含 “计划” 二字就匹配成功；
- 求和区域 $B2:$G2：锁定列范围、行号随下拉自动变化，取当前行对应列的数值求和。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-07-24 10:29:06 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/873686.html
- 运行时间 : 0.181877s [ 吞吐率：5.50req/s ] 内存消耗：4,647.48kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=a27ebfa24f4d4529d368f4923639c791
- CONNECT:[ UseTime:0.000499s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000737s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.017761s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000313s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000617s ]
- SELECT * FROM `set` [ RunTime:0.000237s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000520s ]
- SELECT * FROM `article` WHERE `id` = 873686 LIMIT 1 [ RunTime:0.010287s ]
- UPDATE `article` SET `lasttime` = 1784860146 WHERE `id` = 873686 [ RunTime:0.060341s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.010339s ]
- SELECT * FROM `article` WHERE `id` < 873686 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004841s ]
- SELECT * FROM `article` WHERE `id` > 873686 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000434s ]
- SELECT * FROM `article` WHERE `id` < 873686 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.001706s ]
- SELECT * FROM `article` WHERE `id` < 873686 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000711s ]
- SELECT * FROM `article` WHERE `id` < 873686 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001077s ]
0.183595s
夜雨聆风