Function cnmb(ParamArray Arr())
Dim f, c, k
f = 0
For Each c In Arr
Select Case VarType(c)
Case vbVariant + vbArray
For Each k In c
If VarType(k) = vbBoolean Then
If k = True Then
f = f + 1
End If
ElseIf IsNumeric(k) Then
f = f + k
End If
Next k
Case Else
If VarType(c) = vbBoolean Then
If c = True Then
f = f + 1
End If
ElseIf IsNumeric(c) Then
f = f + c
End If
End Select
Next c
cnmb = f
End Function