Hello everybody!
So, I need a little help here, as I really don't know how can I do this.
What I have is a excel file with 32 worksheets.
First worksheet is named "calc", the rest are 1,2,3...31 (all days of a month)
What I need the calc to do is this:
------
Fom day:
To day:
E:
S:
B:
------
So "from day" is the day you want to start de sum, and "to day" is the day you want it to end.
E: is the sum of the values on cells E4 from the day "from day" to the day "to day"
S: is the sum of the values os cells E5 from the day "from day" to the day "to day"
B: is E - S
It might be confusing to understand, and I don't know how to properly explain it, so let me show you guys some examples.
----- (what is highlited is what will be done automatically)
Fom day: 01
To day: 04
E: '01'!E4+'02'!E4+'03'!E4+'04'!E4
S: '01'!E5+'02'!E5+'03'!E5+'04'!E4
B: E-S
------
----- (what is highlited is what will be done automatically)
Fom day: 05
To day: 07
E: '05'!E4+'06'!E4+'07'!E4
S: '05'!E5+'06'!E5+'07'!E5
B: E-S
------
Hope you guys can understand what I'm trying to do!
Thanks already a lot for the help!
Bookmarks