好不好在EXCEL中 设定自动求和公式~

按Alt+F11进入代码编辑,然后将下面内容粘贴上去,回到工作表,你只要点击E28那个单元格,就会自动统计那一列的数总和了。Private Sub Worksheet_SelectionChange(ByVal Target As Range)If Target.Column = 5 And Target.Row = 28 Then Cells(28, 5).Value = =Sum(E5:E27)End IfEnd Sub