drums4monty
02-18-2011, 02:22 AM
Hi All
I have a workbook with 63 worksheets, they are all named with club names, I also have a Summary sheet. If say membership Cards is on all of the sheets and the total issues for the month is at D9, is there an easy way to sum all of the D9 entries from the 63 sheets onto D9 on the Summary Sheet? At the moment I use the fomula Durham D9+London D9+Leeds D9 and so on 63 times.
I have a workbook with 63 worksheets, they are all named with club names, I also have a Summary sheet. If say membership Cards is on all of the sheets and the total issues for the month is at D9, is there an easy way to sum all of the D9 entries from the 63 sheets onto D9 on the Summary Sheet? At the moment I use the fomula Durham D9+London D9+Leeds D9 and so on 63 times.