EXCEL 怎样统计选中单元格中加数式的和

来源:百度知道 编辑:UC知道 时间:2024/05/04 11:07:15
比如 A1 1+2
Z5 3+4
如何自动统计 A1 Z5的总和10

请您清楚地表达您的意思好吗???如果你的意思是求工作表中所有含有"+"号的算式的值的话,请您用如下方法:
1、在菜单栏上选"工具"-"宏"-"宏"
2、在第一行中输入“Macro1”,点右边的“创建”
3、在里输入如下内容:
Dim hs As Integer, ls As Integer
dim a As Integer, b As Integer
dim js1 As Integer, js2 As Integer
dim m As Integer, sum As Integer
hs = ActiveSheet.UsedRange.Rows.Count
ls = ActiveSheet.UsedRange.Columns.Count
For a = 1 To hs
For b = 1 To ls
m = InStr(Cells(a, b), "+")
If m <> 0 Then
js1 = Left(Cells(a, b), m - 1)
js2 = Right(Cells(a, b), Len(Cells(a, b)) - m)
sum = sum + js1 + js2
End If
Next b
Next a
Cells(hs + 1, 1).Value = sum
4、在菜单栏上选"工具"-"宏"-"宏"
5、选择“Macro1”,点右边的“执行”

还真不好处理呢