Finding the Last Row, then doing the average of above Cells

[nkf531]

Hi,

I'm trying to figure out how to get to the last row of a column, then above those cells find the Average of only specific columns. Attached is the Example. Thanks!

[StephenR]

If the last row doesn't vary:

Please Login or Register  to view this content.

[nkf531]

Thanks a lot man i appreciate the help

[nkf531]

how do i label this as solved?