|
请做个自定义格式的金额,进行分类汇总的自定义函数
谢谢!!,最好有注释
本帖最后由 sunjing-zxl 于 2012-1-11 17:00 编辑
- Function 汇总(rng As Range, str1 As Range, str2 As Range) '汇总(汇总区域,汇总币种,汇总部门)
- '定义变量
- Dim i As Long, arr
- Dim s As String, n As Double, s As String
- arr = rng '把汇总单元格区域赋值给数组
- For i = 1 To UBound(arr) '循环汇总
- s = rng(i, 2).Text '单元格的显示值赋值给s
- s = Mid(s, 2, Len(str1)) '获取汇总区域货币种类
- If s = str1 And arr(i, 1) = str2 Then '当条件打到时进行汇总
- n = n + arr(i, 2) '汇总计算
- End If
- Next i
- 汇总 = n '将汇总值赋值给函数
- End Function
复制代码附件:
Book1-sunjing-zxl.rar
(8.81 KB, 下载次数: 21)
|
|