Hi all,
I have a sheet of names and scores, and then a formula that list those names and the totals of those scores. How can I move these totals and reference this sheet if it's closed. I've been trying to use SumProduct without much luck. I have attached the sheet and highlighted in green the info I want to save in a separate workbook.
Thanks!
Bookmarks