LinkBack URL
About LinkBacks
If you meant to average the middle cells excluding the topmost and the bottommost.. then try:
=AVERAGE(INDEX(A1:A6,2):INDEX(A1:A6,COUNT(A1:A6)-1))
If you meant to average the middle cells excluding the topmost and the bottommost.. then try:
=AVERAGE(INDEX(A1:A6,2):INDEX(A1:A6,COUNT(A1:A6)-1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks