I have this formula =AVERAGE(TAKE(TOROW($F$9:$P$9,1),10)) that averages the last 10 scores. When I add a column to add new scores it changes from F9 to P9 to F9 to Q9. How do I keep the formula to only average from F to P
I have this formula =AVERAGE(TAKE(TOROW($F$9:$P$9,1),10)) that averages the last 10 scores. When I add a column to add new scores it changes from F9 to P9 to F9 to Q9. How do I keep the formula to only average from F to P
Where/how are you adding new columns. Please upload a SMALL sa,ple file (see yellow banner about sample sheets - top of page).
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Blind guess (without seeing what you EXPECT to get)
=AVERAGE(TAKE(TOROW($F$9:$P$9,1),,10))
or maybe
=AVERAGE(TAKE(TOROW(INDEX(9:9,6):INDEX(9:9,16),1),,10))
Formula is in E column. I am right clicking on G column and inserting column. This will allow me to add weekly scores but I only want 10.
Try:
=AVERAGE(TAKE(DROP(F9:O9,,1),,10))
your previous formula was NOT returning 10 values, by the way. The hidden column (F) was messing things up. Now it's OK.
Thank you very much!! That works perfect!!
You're welcome. Thanks for letting us know that you got an answer.
Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks