How to add quotes to variable references

[feormad]

In example below I need to add quotes around the last cell reference and to same formula across columns.
I didn't add quotes because autofill doesn't work with quotes.
Thank you in advance
=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!"&"$B$35:$B$1000"),$A2,INDIRECT("'"&SheetList&"'!"&M$35:M$1000)))

 

[Chrisdontm]

It seems like you could use "FIND & REPLACE"

Have it find everywhere it sees: ))) and replace with with: ")))