I am using this formula "=SUMPRODUCT(('wk52'!$D$6:$AD$6=Summary!$K11)*('wk52'!$D$78:$AD$78))" in my Excel spreadsheet but I would like to set the worksheet name "wk52" as variable, please advise how to convert this formula by using the variable and the functions (indirect, address).
Thanks.
Thanks.