Sum on Indirect sheets with Variable Column and Row References

[wrobbins]

Hi --

I am trying to sum a dynamic range on a dynamic sheet using the formula: =SUM(INDIRECT(""&A17&"!"&"D7:M7")) where A17 is my variable sheet name. I would like to substitute D7 with INDIRECT(C11&C10) and M7 with INDIRECT(C12&C10), where

C11 is my starting Column Letter and C10 is my starting Row Number; and

C12 is my finishing Column Letter and C10 is my finishing Row Number; however

I get a #REF when I do this and suspect there is a SUMPRODUCT or Array formula answer. Any help much appreciated!

Thanks,
Wayne

[FDibbins]

It would probably be easier if you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[wrobbins]

Thanks -- attached is a clean example:

Appreciate any assistance!

[FDibbins]

Based on your sample...
=SUM(INDIRECT(""&A17&"!"&C11&C10&":"&C12&C10))

you may need to absolute some of those ranges if you intend copying that

[wrobbins]

That's perfect - thank you so much!

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)