Hi, before posting this question I looked for similar others in this forum but could not find any answer. In any case apologies to the entire community if this was already asked and answered to.
This is my question:
-I have a row named "REVENUE" showing correspondent revenue values in $ from C3 to N3
-Above the REVENUE row there is another row named "MONTH" showing the correspondent months of the year from C2 to N2 (1 to 12)
-In cell C10 there is a value to be entered between 1 and 12 (correspondent month of the year)
-In cell C11 there is a value to be entered between 1 and 12 (correspondent month of the year)
Basically C10 and C11 determine the dynamic range of time I want to base my sum of revenue from (for instance 3 to 7 is meant to be the sum of revenue between month 3 and month 7).
How can I create a formula IN A SINGLE NEW CELL ONLY to make this work?
Thanks
Al
This is my question:
-I have a row named "REVENUE" showing correspondent revenue values in $ from C3 to N3
-Above the REVENUE row there is another row named "MONTH" showing the correspondent months of the year from C2 to N2 (1 to 12)
-In cell C10 there is a value to be entered between 1 and 12 (correspondent month of the year)
-In cell C11 there is a value to be entered between 1 and 12 (correspondent month of the year)
Basically C10 and C11 determine the dynamic range of time I want to base my sum of revenue from (for instance 3 to 7 is meant to be the sum of revenue between month 3 and month 7).
How can I create a formula IN A SINGLE NEW CELL ONLY to make this work?
Thanks
Al