Average an entire record

[mmitchell]

I have a table of numbers by month for a given year like

J F M A M etc.
2007 9 1 7 6 9
2008 1 9 3 2 5 etc.

I want the average for the year.

I can't figure out how to do it!

Note: I can't change the way I get this data, it is in that format so That is how I have to deal with it.

 

[pbaldy]

(J + F + M...)/12

If some might be Null like current year data, then I'd probably create a function that accepted each of the months as input parameters, kept track of which had values and which didn't so it could divide by the appropriate number.