Summing same cells in multiple worksheets
Hi,
I have a monthly workbook which consists of a worksheet for each day. These sheets are named 01, 02, 03 etc up to 31. I also have a monthly totals worksheet. I want to sum certain cells on each sheet to show in the monthly sheet.... eg ='01'!E7+'02'!E7+'03'!E7....... Is there a quick way of creating this formula without manually typing it in? Thanks in advance Neil |
All times are GMT +1. The time now is 12:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com