| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a total adding cells from other sheets for a roll-up | Excel Worksheet Functions | |||
| Adding numbers from specific cells in a number of sheets | Excel Worksheet Functions | |||
| adding cells in different work sheets | Excel Discussion (Misc queries) | |||
| adding lots of cells from different sheets | Excel Worksheet Functions | |||
| Adding Cells from Multiple Sheets | Excel Programming | |||
Linear Mode
