答：Sum函數(shù)可以在工作表中求，同樣也可以對VBA數(shù)組求和，如：

                    
                      Sub t2()
                          arr = Array(1, 35, 4, 13)
                          MsgBox Application.Sum(arr)  '對數(shù)組進行求和
                      End Sub

                2、Count和Counta

                     Count和Counta可以統(tǒng)計數(shù)組中數(shù)字的個數(shù)和數(shù)字+文本的個數(shù)。

                    Sub t3()
                         arr = Array(1, 35, "a", 4, 13, "b")
                         MsgBox Application.Count(arr)  '返回數(shù)字的個數(shù)4
                         MsgBox Application.CountA(arr)  ‘返回數(shù)組文本和數(shù)字的總個數(shù)
                    End Sub