当前时间： 2026-07-24 10:16:29
分类：办公文件
评论(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/873687.html
- 运行时间 : 0.118603s [ 吞吐率：8.43req/s ] 内存消耗：4,686.90kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=424f521c3f6b14a0ea862a1dcf00d7f2
- CONNECT:[ UseTime:0.000541s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000918s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000327s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000284s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000650s ]
- SELECT * FROM `set` [ RunTime:0.000235s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000749s ]
- SELECT * FROM `article` WHERE `id` = 873687 LIMIT 1 [ RunTime:0.000479s ]
- UPDATE `article` SET `lasttime` = 1784860146 WHERE `id` = 873687 [ RunTime:0.035204s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000330s ]
- SELECT * FROM `article` WHERE `id` < 873687 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
- SELECT * FROM `article` WHERE `id` > 873687 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001444s ]
- SELECT * FROM `article` WHERE `id` < 873687 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000639s ]
- SELECT * FROM `article` WHERE `id` < 873687 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000642s ]
- SELECT * FROM `article` WHERE `id` < 873687 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.003262s ]
0.120324s
夜雨聆风