操作方法
今天同事在问如何设定一个EXCEL工作簿中所有工作表同一个区域进行合计?比如工作簿里有30各工作表,表名为1,2,3~30;想要对每个表中的A1区域进行合计。但不想手工一个一个去加,想使用最简捷的办法。经过一番查询和实验后得出 最简捷的方法是可使用公式:=SUM('1:30’!A1)······················································································································································