Check cell and sum differents worksheets

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!

It's a bit of a mess but:
if B1 is your start sheet and B2 is your end sheet:
=SUMPRODUCT(SUMIF(INDIRECT("'"&TEXT(ROW(INDIRECT(B1&":"&B2)),"00")&"'!E4"),"<>"))
as an array formula (confirm with ctrl+shift+enter), might work.

It is to change 1 into 01 and 31 into 31 to make sure the sheet names are correct, It seemed ok when I tested it, I've uploaded an example.

I realised as well that it seems to work as a non-array/regular formula as well.

Originally Posted by ragulduy

It is to change 1 into 01 and 31 into 31 to make sure the sheet names are correct, It seemed ok when I tested it, I've uploaded an example.

I realised as well that it seems to work as a non-array/regular formula as well.

Working like a charm! Thanks a lot!

The problem was that my excel is in portuguese, and I translated the formula INDIRECT as INDIRECTO when it actually is INDIRETO

Again, thanks a lot for the help!!