Hello,
I would like a code that can sum a specified column of data and then provide the average of the sums of each column. My model generates a specified number of iterations of column data and I would like to then sum each column and then average these.

For example, I have a sheet called "rates", which the user can specify the number of iterations that can be generated so if the user selects 5 iterations then 5 columns of data is generated over the range F10:1000, G10:1000, H10:1000 etc...

I would like a code that looks for the number of iterations/columns of data generated and then sum each at a specified row say F1010, G1010, H1010 etc... and then average these and display this in a specific cell.

In addition, I would also like an additional functionality in the code that can just sum and then average these columns based on a specified row range.

Any assistance would be appreciated.

Thanks.

PS: This was posted also in http://www.ozgrid.com/forum/showthre...154#post670154