|
Adding Cells in Different Sheets
=sum(firstsheetname:lastsheetname!g53)
-- Don Guillett SalesAid Software "Hazel" wrote in message ... Hi All In the same cell G53 on each sheet in a 50 sheet workbook - I need to add them all together in Sheet1 - say in cell A100, at the moment I'm using the following -- there has to be an easier way than entering =J.Bloggs!G53+J.Smith!G53 etc -- -- Many thanks hazel |
| All times are GMT +1. The time now is 10:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com