I have multiple sheets (new one each week) and a Totals sheet. On each sheet there is a list of names and a column with a number. The Totals sheet has a mast list of names. Each week new names are added so the current week has more names than the previous week.
I am trying to add up the total on each sheet for each name and present it on the Totals sheet.
Sheet 1 (week 1)
Sheet 2 (week 2)
I've been working with this site: https://www.extendoffice.com/documents/excel/2450-excel-vlookup-in-multiple-sheets.html#a1
I've also been playing with this formula: =SUMPRODUCT(VLOOKUP(A4,IND
I am using an array formula that uses a sheet that lists all the other sheet names.
Thanks for any help you can provide.