Hello,

I'm new here, hope you experts can find me a solution.

I would like to sumif across multiple sheets. Each tab represents one week, each row represents one property. I had previously created a formula that would look up the property and sum across all weeks to get a running YTD total, which worked fine, but now that same formula when applied here does not work.
Here is the formula I used:

=SUMPRODUCT(SUMIF(INDIRECT("'"&weeks&"'!"&"a1:a212"),$A7,INDIRECT("'"&weeks&"'!"&"C1:C212")))

Where "weeks" is a named list of sheet names, the locations are all in Column A, and the sum range is in Column C

Any idea why this is not working? I am getting #REF error