一个奇怪的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…