my first experince with MEDIA calculation

[sal21]

I have 16 element in array, during the loop of array i summ a value of the item 1.
The actual summ is 134.456,89

How to calculate the MEDIA of week, month and year, based the numbers of the 16 elelments?

[HansV]

Do you mean the average?

And what exactly do you mean by "MEDIA of week, month and year" if you have an array of numbers?

[sal21]

Do you mean the average?

And what exactly do you mean by "MEDIA of week, month and year" if you have an array of numbers?

Do you mean the average?
YES, sorry (media is Italian definition)

MEDIA = average

The 16 items into array are refered only for one day in my case for 17/07/2014

[HansV]

If you're doing this in Excel, you can use

Dim arr ' This is the array variable
Dim Media As Double
' Code to fill array
...
...
' Compute the average
Media = Application.Average(arr)