LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default formulas for linking cells in different worksheets

I've searched the Excel help topics up and down but can't find a concise
answer to the following...
While working in the same workbook, what is the formula that i need to enter
in a particular cell in one worksheet that will give me the sum of other
cells in different worksheets?
For example, in Sheet 1, i want cell A1 to add up cell B52 from Sheet 2,
cell B52 from Sheet 3, etc...
anyone?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing cells in different worksheets DiiRK Excel Worksheet Functions 1 November 14th 05 07:34 PM
How do I copy only cells with formulas in another row? Soozy Excel Worksheet Functions 2 October 21st 05 08:02 PM
how get rid of cells with unused formulas Benj Excel Discussion (Misc queries) 3 July 8th 05 02:47 PM
Excel 2002 - copying formulas across worksheets Greg Excel Discussion (Misc queries) 1 January 27th 05 10:45 PM
Assigning Cells in worksheets to other data in other worksheets. David McRitchie Excel Discussion (Misc queries) 0 November 27th 04 06:15 PM


All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"