My formula doesn't include the curly brackets { }


"Bongard" wrote:

I copy pasted this exact thing into my cells and it wouldn't work

{=SUMPRODUCT(SUMIF(INDIRECT("'"&MySheets&"'!
C9:C27"),A11,INDIRECT("'"&MySheets&"'!B9:B27"))}

I created the list named my sheets just the way you said, but no go.
I don't really know what I am doing wrong.