Excel 2007 : Finding The Average of the Last 20 Cells in a Column

[Ebikeguy]

Hi All,

This should be simple, but I'm being extra gumbylike today, so I cannot figure it out.

I am trying to find the value of the last 20 cells in a column and paste it into one cell. The number of rows in the spreadsheet will vary from instance to instance.

Any help or suggestions you could provide would be much appreciated.

Just to prove what a gumby I am, here is my current code from my attempts to make this happen:

Please Login or Register  to view this content.

Thanks!

Ebikeguy

[tom1977]

hi I do not understand Your code but let's say You have data in column A than below code will count average of last 20 cells and will put the result in B1

Please Login or Register  to view this content.

[Ebikeguy]

Worked perfectly! Thank you very much! I'm so glad I found this forum!