How to add quotes to variable references

feormad

New Member
Joined
Apr 10, 2019
Messages
1
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

Well-known Member
Joined
May 4, 2015
Messages
802
It seems like you could use "FIND & REPLACE"

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

Forum statistics

Threads
1,085,670
Messages
5,385,103
Members
401,934
Latest member
cwinkel

Some videos you may like

This Week's Hot Topics

Top