一个奇怪的VBA函数：在excel里计算对角线的和
想要计算一个区域里对角线的和，但SUMIF里面的那个criteria实在太简陋了，只能用vba来实现，大概长这样： 引用 Function sum_diag(n As Integer, ParamArray args() As Variant) As Variant result = 0 For i = LBound(args) To UBound(args) For Each elem In args(i) If elem.Row + e…
想要计算一个区域里对角线的和，但SUMIF里面的那个criteria实在太简陋了，只能用vba来实现，大概长这样： 引用 Function sum_diag(n As Integer, ParamArray args() As Variant) As Variant result = 0 For i = LBound(args) To UBound(args) For Each elem In args(i) If elem.Row + e…