Hi there,
I've got a range of workbooks, one for each month, and the tabs that are in each are the date of the month - I can't just put 1,2,3...29,30,31 etc, they need to be 010711, 020711, etc because that's the way the report creates them and it would take too long to rename each, but I need a formula to sumif over a multiple range of sheets, but that can be transferred between months, so I don't really want to have to use the sheet list in sumproduct, as it would mean creating an extra sheet each new month with the list with all the tab names...... soooo... anyone got any suggestions?
I want to sumif (tabs2-32)B1, tab 1A1, (tabs 2-32)C1
where the tabs range names will change for each new book.
I'm working with Excel 2003.
Thanks!!
Ceri
I've got a range of workbooks, one for each month, and the tabs that are in each are the date of the month - I can't just put 1,2,3...29,30,31 etc, they need to be 010711, 020711, etc because that's the way the report creates them and it would take too long to rename each, but I need a formula to sumif over a multiple range of sheets, but that can be transferred between months, so I don't really want to have to use the sheet list in sumproduct, as it would mean creating an extra sheet each new month with the list with all the tab names...... soooo... anyone got any suggestions?
I want to sumif (tabs2-32)B1, tab 1A1, (tabs 2-32)C1
where the tabs range names will change for each new book.
I'm working with Excel 2003.
Thanks!!
Ceri
