Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel General
Average Question
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="BobA, post: 7426068"] Hi Bob, Am Tue, 28 Jan 2014 08:18:07 -0800 (PST) schrieb BobA: - show quoted text - try: =AVERAGE(OFFSET($A$2,,,COUNT($A$2:$A$100)-1)) Regards Claus B. Thank you, Claus. I wish I understood this formula better, specifically the offset function and the three commas after $A$2,,, but it works perfectly and is just what I needed. Much appreciated [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel General
Average Question
Top
