Hello. I've attached a sheet that has an offset and choose formulas that selects the value of the last month of a quarter. I would like to change this formula to look at the WHOLE quarter (and year) and come up with an average. Am I able to modify the current formula or are there better formulas to do this? Spreadsheet attached. Thanks.
Hi,
One way in O8 copied across
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
@buttrey...Thanks. B8 should be a fixed reference right?
I noticed you get anwers to your questions, but you don't respond on the given answers.
Most forummembers wants to know if the given solution match your expectation.
e.g.
http://www.excelforum.com/excel-gene...n-vlookup.html
http://www.excelforum.com/excel-gene...ml#post3719898
http://www.excelforum.com/excel-gene...n-a-month.html
http://www.excelforum.com/excel-prog...ml#post3715812
http://www.excelforum.com/excel-gene...ml#post3712954
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
No. It should be a relative reference, as no doubt you'll discover if you change it to an absolute ref, copy it across and find you have the wrong answersOriginally Posted by ammartino44
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks