Performing Calculations on Array Data

Hi,

I have some code which parses data coming from a trading client and arranges it into an array. I would like some help on how to go about performing calculations on the array data. Specifically, for example, how would I sum everything in column 2 of the array created. By the way, this array is constantly updated as trades come in. I am not familiar at all when it comes to arrays and programming. Any help would be great. The code for the parser is as follows:

#Function PARSERTD(str As String) As Variant

'' This function is used to parse the row & semi-colon delimited data output from RIT into a table

Dim Rows() As String
Dim Cols() As String
Dim NoR As Integer
Dim NoC As Integer
If Len(Trim(str)) = 0 Then
ReDim Res(0, 0) As String
PARSERTD = Res
Else
Rows = Split(str, ";")
Cols = Split(Rows(0), ",")
NoR = UBound(Rows)
NoC = UBound(Cols)
ReDim Res(NoR + 1, NoC) As String
For i = 0 To NoR
Cols = Split(Rows(i), ",")
For j = 0 To NoC
Res(i, j) = Cols(j)
Next j
Next i
PARSERTD = Res
End If#

Welcome to the forum.

Please enclose the code using code tags "#"