Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

оставшийся без ответа Updating sum and average range references based in a cell refefernce

More
3 months 2 weeks ago #1783 by Dias
I have sum and average formulas that show different metrics from prior years and compares them to the same metric for the YTD of the current year.  I want the prior years to display the same YTD information based on the week number of the current year.
For example, for the prior years the data is in columns B:BB.  For the current year(Week 33) the data is in columns B:AH.  Again, for example purposes, I have a formula =sum('2018'!B4:BB4) that shows me the sum of the entire year of 2018.  I need the formula to say =sum('2018'!B4:AH4) and th4 AH reference be automatically update each week based on a cell containing the week # or column reference. 

Lisa6538

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun