I am trying to figure out an easy way to find the average of all the values I have stored in an array.

Dim StoredValues(3) as integer
Dim AverageValue as integer

AverageValue = 'Code to return the average of the 4 values stored in StoreValues


Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.

__________________
Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.

Hi Jeff,

I couldn't get the point, what you mean by easy way?
Loop through array , get the sum and divide by the upper bound. Do you mean something else?

Anubhav Kumar

I was hoping there was an average function. I know there is in VBA and I have used it numerous times. I am using something that sounds similar to what you just described only I'm just summing all items in the array and dividing by a counter that keeps track of how many times it goes through the loop to get all the values out of the array.


Jeff Armstrong
Sr. Systems Mgr
SBC Services, Inc.