Calculate MTD with Sumif SumProduct Indirect

[leighnea]

=SUMPRODUCT(SUMIF(INDIRECT("'"&list&"'!d2:d100"),D11,INDIRECT("'"&list&"'!e2:e100")))


This is the formula I used and this adds all 31 tabs however I need to sum only based on what day the report is being ran for.

 

[Domenic]

How are the sheets named? If, for example, the sheets are named 1, 2, 3, etc., try...

=SUMPRODUCT(SUMIF(INDIRECT("'"&ROW(INDIRECT("1:"&DAY(TODAY())))&"'!D2:D100"),D11,INDIRECT("'"&ROW(INDIRECT("1:"&DAY(TODAY())))&"'!E2:E100")))

If the sheets are named Sep 1, Sep 2, Sep 3, etc., replace...

ROW(INDIRECT("1:"&DAY(TODAY())))

with

TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),ROW(INDIRECT("1:"&DAY(TODAY())))),"mmm d")

If the sheets are named 09/01/14, 09/02/14, 09/03/14, etc., replace...

ROW(INDIRECT("1:"&DAY(TODAY())))

with

TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),ROW(INDIRECT("1:"&DAY(TODAY())))),"mm/dd/yy")

Hope this helps!